Dear all,

First of all, I want to thank you for your contributions to this forum, I have truly learned a lot.

My question: without using Power Query, how do I unpivot the 'input' table? I have attached an example of how I would like the output to be.

I would like to make it dynamic so whenever I add a new column or row, the table automatically updates.

Thanks!

Unpivot Example Sheet.xlsx

Screenshot 2023-06-04 at 14.18.21.png