How would I take multiple columns and combine them into a single column?

[Anonymous]

I have reports sent to me from various sources with columns for each month of the year. I would like to take said columns and combine them all into a single column programmatically and associate the month from which they originated with them.

Is there an easy way to do this? I see the "Convert to List" feature, but I can't figure out how to do this for all columns without having to create separate queries for each. I am also unsure how I go about recombining them.

[MarcoRotta · Accepted solution]

Hi pbiuser2.

What you probably want here is to unpivot those months columns and turn them into a single column. Your data model will probably not work fine with them pivoted as they are. I've found this blog post with detailed instructions on how to do it. Take a look. The first part of the post deals with pivoting, so please roll to the middle of the article to find the unpivotting topic. 

Regards. 

[Anonymous]

@MarcoRotta, that is brilliant! Thank you!