Are you wanting to unpivot a crosstabulated table?
Can you post an example before and after shot, so your intent is clearer?
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?
Excel 2010, Tables, PivotTables, PivotCharts
De-normalize an array with two levels of row and column headers.
With macro.
http://8936e6d9f85be098ae08-f26298a4.../07_09_12.xlsm
If you get *.zip, don't unzip, just rename *.xlsm
Bookmarks