Forum Discussion
ferryh
Advocate I
9 years agoTransforming 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