tranform coloumn to row

[Anonymous]

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

[wdx223_Daniel]

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

[Anonymous]

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

[Anonymous · Accepted solution]

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.