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

Transforming long data to a single column

Hi all, I have the following situation in which I attempt to transform long data (with multiple "genres" per unique title) to a single column, based on the unique title.


As an example, you can see #Redemption (2014) having 4 genres.


The problem in this case is that there are more than 10.000 different "genres", so I cannot first Pivot and then merge all the created columns due to limited column restaints.


Any trick to reshape this long data to a single "genre"  column without using the pivot option?

Doesn't matter if the delimiter is a space or a comma or something.


Kind regards,




Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!


Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors