By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,827 Members | 2,277 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,827 IT Pros & Developers. It's quick & easy.

columns to rows conversion

P: 8
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.
Feb 5 '07 #1
Share this Question
Share on Google+
5 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
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
Feb 5 '07 #2

maxamis4
Expert 100+
P: 295
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
Feb 5 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Feb 5 '07 #4

P: 8
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?
Feb 6 '07 #5

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Feb 6 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.