skip empty rows in different columns

Question

Hey everyone, I have input in below format.

Column 1Column 2Column 3Column 4Column 5Column 6Column 7Column 8Column 9a1         b1         c1d1e1f1g1h1i1a2         b2         c2d2e2f2g2h2i2         a3

I am hoping for output in below format

Column 1Column 2Column 3Column 4Column 5Column 6Column 7Column 8Column 9a1b1c1d1e1f1g1h1i1a2b2c2d2e2f2g2h2i2a3b3c3d3e3f3g3h3i3

I would really appreciate any guidance in correcting format of the data alignment. Thank you in advance!

binu_acs · Accepted Answer

@i_m_AB One way of doing this

ddiesel · Accepted Answer

Hi @i_m_AB!

Here's another way:

Hope this helps!

Thanks,
Deb