How to convert row to column

[nandanwin]

Hi guys I have data like this two columns ticket I'd, order id

Ticket I'd ,ordered

1,             2763627,A6727277,387272

2,             6272778,U7277273

3,             727336

I want convert it as 

1 2763627

1 A67272...

1 3873.....

2 6272..

2 U72...

3 .....

[AlexisOlson · Accepted solution]

You can do this with just a few clicks using Split Column > By Delimiter and choosing to split into rows under the advanced options:

[wdx223_Daniel]

NewStep=#table(Table.ColumnNames(PreviousStepName),List.TransformMany(Table.ToRows(PreviousStepName),each Text.Split(_{1},","),(x,y)=>{x{0},y}))