Transposing cell values to newly created columns

[krnstpn]

Hi, 

I am cleaning a dataset, and i want to transpose the values of a cell to a newly created column to separate the values into vertical layout.

Example, from this layout:

Customer

C1-0000001

Mary Ann Williams

18 CONGRESSIONAL AVENUE

NEW YORK

UNITED STATED

C1-0000002

John Smith

9TH ELM ST.

NEW JERSEY

UNITED STATED

To this:

Customer Number	Customer Name	Address
C1-0000001	Mary Ann Williams	18 CONGRESSIONAL AVENUE NEW YORK UNITED STATED
C1-0000002	John Smith	9TH ELM ST. NEW JERSEY UNITED STATED

[seefadeeb]

Hi @krnstpn

See my attached flow with solution.

[c-lopez]

Hi,
@seefadeeb's solution is perfect, but just for fun here is a second one.

I hope it helps!