Not sure how to even title this - transform 3 columns into 2

[charbaugh]

This may not be possible, but I wanted to ask the experts here.  I have a table that looks similar to this.

I need to transform this so that my column headers are [Month Name], [Brand], and [Sales].  The output would have 3 rows for each month and would look something like this:

I appreciate any help.

[Greg_Deckler]

Sure, just right-click Month Name in Power Query Editor and choose Unpivot other columns.

[Mariusz · Accepted solution]

Hi @charbaugh 

You can use Power Query Editor's Unpivot task 

https://www.youtube.com/watch?v=-IMqkg35adA

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[charbaugh]

That was too easy.  Thanks!