You are reading a single comment by @moocher and its replies.
Click here to read the full conversation.
-
What I'd do here is use PowerQuery to unpivot those Type columns.
https://www.excel-university.com/unpivot-excel-data/
I'm not sure if that's an option looking at your version of Excel though so otherwise you can use this macro.
https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/31387513-unpivot-data-without-powerquery-or-macroThen just pivot on the resulting data
aggi
@moocher
pivot tables
is it possible to use a pivot to get from the first layout to the second? i dont seem to be able to, but if it is then i can persevere.
so, columns become a row and are replaced by a current row
2 Attachments