columns to rows conversion

[hasnain]

I have excel sheet of 6 columns and what I want to do is keep my first column as it is and all the other 5 columns (different headers) should be converted into rows and value of first column must be repeated five times with rows as well.

[MMcCarthy]

I have excel sheet of 6 columns and what I want to do is keep my first column as it is and all the other 5 columns (different headers) should be converted into rows and value of first column must be repeated five times with rows as well.

You are looking to transpose the columns into rows. Try selecting the relevant columns and data, copy and go to a new sheet now go to edit - paste special and there is an option called transpose. Play around with this and see if it does what you want.

Mary

[maxamis4]

Mary,

Its different but you want to do is a cross tab query. That way you can paste your rows into the new table.


Let me know how i can help

[MMcCarthy]

Mary,

Its different but you want to do is a cross tab query. That way you can paste your rows into the new table.


Let me know how i can help

Hi max

I just assumed we were talking about Excel only but you may be right. Will have to wait for the OP to get back.

Mary

[hasnain]

Hi max

I just assumed we were talking about Excel only but you may be right. Will have to wait for the OP to get back.

Mary

Thanks mmccarthy
I want solution in Access, I have tried crosstab query but unfortunately It didn't work. Can you explain that how I can use crosstab query for this?

[MMcCarthy]

Thanks mmccarthy
I want solution in Access, I have tried crosstab query but unfortunately I didn't work. Can you explain that how I can use crosstab query for this?

I need more information.

1) What are the names of the 6 columns
2) Explain in english rather than by refering to columns what information you want to see in your results. I'm not sure a crosstab query is what you want as this is usually a way of representing an agregate value (sum, count, etc) of one colums under the headings of the values in another column. It doesn't sound like this is what you want.

Mary