Move Row Up

Question

Hi Team ,

I want to move the data from row 3 to row 2 beside Grand total, kindly help me to sort out the issue.

Attaching the File and screenshot for your refernce.

Output.xlsx

jrlindem · Accepted Answer

I would filter the data to remove the current "Grand Total" row with the nulls, using the [Account Number] and then just add the label back using a Formula for the other record:

(disregard the data errors and warnings.  I just grabbed a chunk of your data and threw it into a text input tool)

Hope this helps, -Jay

Qiu · Accepted Answer

Lets try a bit different approach with @jrlindem