Transpose matrix-style table to 3 columns in Excel
- by polarbear2k
I have a matrix-style table in excel where B1:Z1 are column headings and A2:A99 are row headings. I would like to convert this table to a 3 column table (column heading, row heading, cell value). It does not matter in what order the new table is.
A B C D A B C A B C
1 H1 H2 H3 1 H1 R1 V1…