Forum Discussion
Copying/Transfrom multiple columns under each other.
- 3 years ago
HI,
you could unpivot the columns in power query. If you are likely to have more quarters than just the 3 listed there - select all the columns except the quarters, right click and select unpivot other columns.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
- 3 years ago
Okay, so all you have to do is go into power query select the ones you don't want in one column, right click the selection and select unpivot other columns
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
HI,
you could unpivot the columns in power query. If you are likely to have more quarters than just the 3 listed there - select all the columns except the quarters, right click and select unpivot other columns.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍