skip empty rows in different columns

[i_m_AB]

Hey everyone, I have input in below format.

Column 1	Column 2	Column 3	Column 4	Column 5	Column 6	Column 7	Column 8	Column 9
a1
	b1
		c1	d1	e1	f1	g1	h1	i1
a2
	b2
		c2	d2	e2	f2	g2	h2	i2
a3

I am hoping for output in below format

Column 1	Column 2	Column 3	Column 4	Column 5	Column 6	Column 7	Column 8	Column 9
a1	b1	c1	d1	e1	f1	g1	h1	i1
a2	b2	c2	d2	e2	f2	g2	h2	i2
a3	b3	c3	d3	e3	f3	g3	h3	i3

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

[binuacs · Accepted solution]

@i_m_AB One way of doing this

[ddiesel · Accepted solution]

Hi @i_m_AB!

Here's another way:

Hope this helps!

Thanks,
Deb