I have hundreds of rows and columns in a table formatted like table A. I want it to be structured like table B. so I can summarize. How do I do that? I'm not an SQL guru by any means, but I work with some people who are.
Thank you for your help.
Table A-What I have
Item 123 456 789
ABC 1 2 3
LMN 4 5 6
XYZ 7 8 9
Table B-What I want
Item
ABC 123 1
LMN 456 2
XYZ 789 3
ABC 123 4
LMN 456 5
XYZ 789 6
ABC 123 7
LMN 456 8
XYZ 789 9
Cross-posted here: http://www.mrexcel.com/forum/microsoft-access/853441-transposing-data.html
Thank you for your help.
Table A-What I have
Item 123 456 789
ABC 1 2 3
LMN 4 5 6
XYZ 7 8 9
Table B-What I want
Item
ABC 123 1
LMN 456 2
XYZ 789 3
ABC 123 4
LMN 456 5
XYZ 789 6
ABC 123 7
LMN 456 8
XYZ 789 9
Cross-posted here: http://www.mrexcel.com/forum/microsoft-access/853441-transposing-data.html
Last edited by a moderator:
