TRANSFORMING FROM HORIZONTAL POSITION TO VERTICAL VALUES

Question

Hi I would just like to ask if how can I change the position of my data into vertical.

I have a data here:

Column1Column2Column3Column4Column5AppleBananaOrangeEggplantCherry

Expected output:

Column1AppleBananaOrangeEggplantCherry

atcodedog05 · Accepted Answer

Hi @dunkindonut7777

Use transpose like below.

Workflow:

Hope this helps : )

binay2448 · Accepted Answer

Hope this will help..