0

I have a dataset which has multiple genres for movie, I want to make multiple rows with same movie name but each time with different genre in excel

example:

dataset I have:

movie genre1 genre2
abc horror action
efg comedy drama

dataset I want:

movie genre1
abc horror
abc action
efg comedy
efg drama
Yash Vishe
  • 61
  • 8
  • 1
    This is called unPivot and the best tool for this is power query. See here: https://stackoverflow.com/questions/20541905/convert-matrix-to-3-column-table-reverse-pivot-unpivot-flatten-normal – Scott Craner Dec 20 '22 at 19:36

0 Answers0