3 Replies Latest reply on Apr 3, 2018 10:44 PM by Atul Nagar

    separating column data into rows

    Atul Nagar

      Hi,

       

      I have an issue with one of the dashboard which requires data cleaning. Most of the multi select values are aggregated in data source and I need to clean and seperate them into columns. I do not have access to data source and need to figure this out at reporting level.

       

      For example - data in below format

           

      NameCountryStateProductsAmount
      AlexUSATexas#Florida#OhioScale#Pen#Pencil50

       

       

      Needs to be converted into

       

       

      NameCountryStateProductsAmount
      AlexUSATexasScale50
      AlexUSATexasPen50
      AlexUSATexasPencil50
      AlexUSAFloridaScale50
      AlexUSAFloridaPen50
      AlexUSAFloridaPencil50
      AlexUSAOhioScale50
      AlexUSAOhioPen50
      AlexUSAOhioPencil50

      Please let me know if you have suggestions.