Remove empty cells and align values

[videet]

I want to format input table as output shown below/

Any idea how it can be done?

Input table

Staff ID	Val1	Val2
100
	2096	873
101
	2634	1098
102
	2448	1020
103
	3464	1443
104
	1920	800

Expected Output

Staff ID	Val1	Val2
100	2096	873
101	2634	1098
102	2448	1020
103	3464	1443
104	1920	800

[atcodedog05 · Accepted solution]

Hi @videet 

Here is what you do.

Workflow:

1. Using data cleanse tool to remove empty spaces.

2. Using muti-row formula tool is current row staff id is null take from above row.

3. Using filter tool to remove rows where val is empty

Hope this helps 🙂

[videet]

@atcodedog05 ,

Thanks buddy you have been life saver for me!!

Cheers!!

[atcodedog05]

Happy to help @videet 🙂