I have data in an array/grid like this:
Name | Group | A1 | A2 | A3
name1 | Group1 | 14.95 | 19.95 | 0.00
name2 | Group2 | 4.95 | 9.95 | 12.95
name3 | Group2 | 49.95 | 0.00 | 0.00
And I need a way (without VBA if possible) to turn the data in to 4 columns
name1 | Group1 | 14.95 | A1
name1 | Group1 | 19.95 | A2
name1 | Group1 | 0.00 | A3
name2 | Group2 | 4.95 | A1
name2 | Group2 | 9.95 | A2
name2 | Group2 | 12.95 | A3
name3 | Group2 | 49.95 | A1
name3 | Group2 | 0.00 | A2
name3 | Group2 | 0.00 | A3
I've tried paste-transpose and pivot tables, but everything I know requires lots of manual deletion to get the items to line up.
Any help will be greatly appreciated.