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...
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.

     

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.