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.
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.