How to delete empty cells from whole table and shift cells up

[wcamarg3]

Hi everyone,

I hope anyone can help me.

I have a table with so many columns, and each column has some empty cell. I would like to delete the empty cells.

Below an example of what I desire:

Original table:

Field 1	Field 2	Field 3	Field 4
123
589		896
	583
245			245
		245
2130
578			109

Desired outcome:

Field 1	Field 2	Field 3	Field 4
123	583	896	245
589		245	109
245
2130
578

I hope anyone can help me.

Many thanks,

Wilson

[KarolinaRoza · Accepted solution]

Hi @wcamarg3 

It was not straight forward but I got it!

Hope it helps you

Karolina

[Qiu · Accepted solution]

@wcamarg3 
I hope I can help with a bit different approach.

[wcamarg3]

Marvelous solution @KarolinaRoza ! Thank you so much!

[wcamarg3]

Thank you @Qiu 

[Qiu]

@wcamarg3 
Glad to help and thank you so much for your mark.