I want to format input table as output shown below/ Any idea how it can be done? Input table Staff IDVal1Val2100 2096873101 26341098102 24481020103 34641443104 1920800 Expected Output Staff IDVal1Val210020968731012634109810224481020103346414431041920800

Remove empty cells and align values

I want to format input table as output shown below/

Any idea how it can be done?

Input table

Expected Output

Workflow

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 🙂

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 🙂

Thanks buddy you have been life saver for me!!

Cheers!!

Happy to help @videet 🙂