Remove empty spaces across multiple columns and get data across rows on same level

[Shaina1]

Hi, I have an input data of the form as shown in screenshot-I essentially want to get the data on the same level and keep the original columns. Attaching input and expected output. Is there any dynamic way for doing this ? 

[ShankerV]

@Shaina1 

Yes it is possible, can you please share the input in .xlsx format.

Many thanks

Shanker V

[IraWatt]

Hey @Shaina1,

there are a few ways to do this. One way is just to separate out the columns and filter away the empty rows and join on record position:

[Shaina1]

Hey-thanks for this ! Actually my dataset is extremely large-so I would have to repeat this process across multiple columns and processes which might be a bit cumbersome. But thanks a lot for replying on my post.

[IraWatt · Accepted solution]

Ahh @Shaina1 here is a dynamic way:

[Shaina1]

Thanks a lot for this :) Exactly what I wanted !

[IraWatt]

Great to hear @Shaina1 have a good one !