Split one column into two and keep rest of the columns

[Reddy4]

I tried Crosstab and Transpose but it didn't work. Can someone please help me out figuring this one.

My input table is something like below:

 and I want Output as:

[fmvizcaino]

Hi @Reddy4 ,

You almost got it right! Attached is an example where I'm using a tile tool to allocate the input6 to different columns.

Take a look and let me know if this works for you.

Best,

Fernando Vizcaino

[saibal_78 · Accepted solution]

Slightly different approach 🙂

[Reddy4]

Thank you, it works perfectly