Grouping columns

[rob1]

Hi Everyone,

I would like to re-arrange columns in the following format

Account #	2014 Product A	2014 Product B	2015 Product A	2015 Product B
1
2

I would like to re-arrange to

Account #	Year	Product A	Product B
1	2014
1	2015
2	2014
2	2015

Any help would be much appreciated

Rob

[Garrett · Accepted solution]

Rob,

Looks like a job for Transpose, Text to Columns, and a Cross Tab tool.  See attached.

Garrett

[rob1]

Thanks! That's perfect.