1 2 Previous Next 28 Replies Latest reply on Oct 26, 2017 7:13 AM by Shinichiro Murakami

    Converting columns to multiple rows

    Aditya Balgi

      I am working with packaged work book. It has movie data with a field for Genres whiich contains multiple pipe separated values(eg. Action|Adventure|Animation)

      i believe i need to split the genres into separate rows for each movie. Can someoen guide me on how to accomplish this.

      the split function only transforms the data into multiple fields which is not what i need. Note (I do not have access to the raw excel data)

        1 2 Previous Next