Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

tranform coloumn to row

hey team,
i have an excel file with a  column that contains names,role, and companies of the users, 

 

I want to transform A3 to b2, a4 to c2,a5 to a3, a6 to b3, and a7to c3... ie every name should be in the name column, role in the role column and company in company column

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    You could transpose the Name column and then use the first row as the headers.

    1.Transpose

     

    2.Use first row as headers

     

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

3 Replies

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Icon for Community Champion rankCommunity Champion
    4 years ago

    =#table({"Name","Role","Company"},List.Split(PreviousStepName[Name],3))

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks, this is throwing error in power query, Can you please eloborate it

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi Anonymous ,

         

        You could transpose the Name column and then use the first row as the headers.

        1.Transpose

         

        2.Use first row as headers

         

         

         

        Best Regards,

        Stephen Tao

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.