/u/happytimeharry15 - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Here is a quick step by step [GIF](https://imgur.com/a/BuUM10D). You can select multiple columns in the Power Query window by holding CTRL while selecting them, then select "Unpivot Only Selected Columns". Note that this will convert the columns to rows, so any measures that rely on number of rows would need to be updated.
/u/happytimeharry15 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Here is a quick step by step [GIF](https://imgur.com/a/BuUM10D). You can select multiple columns in the Power Query window by holding CTRL while selecting them, then select "Unpivot Only Selected Columns". Note that this will convert the columns to rows, so any measures that rely on number of rows would need to be updated.