Forum Discussion

ferryh's avatar
ferryh
Icon for Advocate I rankAdvocate I
9 years ago

Transforming long data to a single wide column (without pivot)

Hi all, I am having difficulties trying to reshape the long data from my (large) dataset into a single column.

As shown in the below picture, I am aiming to merge all "genres" per unique title into a single column

 

Typically I would try to use the pivot & merge options, BUT the problem is that there are more than 10.000 different genres.

So I cannot use the pivot option, because I am sure there is a constraint to how many columns I can create.

 

 

The goal is to, in this example, create 1 column for Redemption (2014) which has 4 different "genres"

 

Is there any option / formula to reshape the data in PowerBI so that it can create such a column without having to pivot ?

 

Kind regards,

 

Ferry

No RepliesBe the first to reply