Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Transformationhelp

  I have excel file with this format where in one colum values are repeating. I have attached an example below. I want to use column1 values as column header but not repeated column. values in colum...
Need Help
  • camargos88's avatar
    camargos88
    6 years ago

    Hi Anonymous ,

     

    Check this file: Download PBIX 

     

     

    Did I answer your question? Mark my post as a solution!
    Ricardo

camargos88's avatar
camargos88
Community Champion
6 years ago

Hi Anonymous ,

 

Check this file: Download PBIX 

 

 

Did I answer your question? Mark my post as a solution!
Ricardo

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks for the solution. In my data i have more than 20 columns. Can i use the same approch ?

    • camargos88's avatar
      camargos88
      Community Champion
      6 years ago

      Anonymous ,

       

      Yes.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Do i have to make any chanegs in custom column ?