Showing results for 
Search instead for 
Did you mean: 
New Member

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,



Helpful resources

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors