Repeat items and delete subtotals

[MiroPwC]

Hey guys,

I would like to ask you for your help with part of my flow.. I am sending you excel where you have 2 sheets.. First one consists of raw data. The point is to repeat Account number for all blanks above the row with account number and then delete this subtotal row. You can see desired output in the second sheet, where the selected account number will be in each relevant row  + the subtotal row is deleted.

May I ask you for help with this as I have never experienced something like this.

Thanks a lot.

[JosephSerpis · Accepted solution]

Hi @MiroPwC I mocked up a workflow that produces your desired output let me know what you think?

[MiroPwC]

Works like magic 🙂 Thanks a lot