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

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 ? 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Also in my case index are not coming as 1 2 1 2 .  it is coming as 1 2 3 4...

      • camargos88's avatar
        camargos88
        Community Champion
        6 years ago

        Anonymous ,

         

        Can you provide sample data ?

         

        Ricardo