Transpose cross-header table into a relational table

parahumanoid

New member
Joined
Apr 19, 2013
Messages
3
Reaction score
0
Points
0
Location
A, A
I am looking for a native way (or a macro) that would take a table that has column headers and row headers and use those as cell values for new column1 and column2 while column3 would be filled with the cell values of the original table, thus yielding a relational DB-style table.

Thanks a bunch, guys.
Alex.
 
Are you wanting to unpivot a crosstabulated table?

Can you post an example before and after shot, so your intent is clearer?
 
Back
Top