Forum Discussion
Table transformation with PivotTable or Index Match
I have an Excel 2016 file with a large set of panel data in the following actual form: VAR ISO VALUE 1990 1991 1992 IMPORTS ARG 1,287 NA NA IMP...
You posted your question in two spaces, better to keep in one. Anyway, please clarify that https://techcommunity.microsoft.com/t5/Excel/Transform-table-format-with-multi-level-variables-maybe-with/m-p/210979#M7105