Adding rows with specific data before starting of each set of data

[deepakshaw1991]

My Data:-

Required Data:-

Thanks in advance.

[atcodedog05]

Hi @deepakshaw1991 

Can you provide this data in excel.

Happy to help 🙂

[deepakshaw1991]

@atcodedog05 Sorry I am not authorised to upload files. Please help me!!

[deepakshaw1991]

@atcodedog05 You can use any fictitious data.

[atcodedog05 · Accepted solution]

Hi @deepakshaw1991 

Here is how you can do it.

Workflow:

Hope this helps : )

[deepakshaw1991]

Hi @atcodedog05 ,

Hope you are doing well.

Sorry for late reply.

Solution provided by you is exactly what I wanted. I have implemented the solution in my workflow and as a result I am able to achieve the desired output and its solve my purpose.

Thanks for helping.

Have a great day ahead.

Regards,

Deepak

[Akash__on]

but in question you asked for the File Name in the Number field as well 

only a little tweak in @atcodedog05 above solution. Added a formula field after the summation tool

and changing the sorting to descending for the "Number field"

[atcodedog05]

Happy to help : ) @deepakshaw1991 

Cheers and have a nice day!