Remove empty Rows and adjust the rows consistently

[geeklarokcmie]

Please find the attached xls file titled : "sample"  with two tabs

- Input

- Expected Output

I have ran a workflow (attached) and I couldn't get past on how to remove the empty rows and adjusted them as per the expected output tab.

Please guide me with the next steps. Thank you

[muhammad_bhatti · Accepted solution]

let me know if this helps; 

[Raj]

@muhammad_bhatti Great logic.

[geeklarokcmie]

@muhammad_bhatti You are a GENIUS!!

Thank you for providing this solution. It works seamlessly.