Add a new line to label a group

Question

Hi,

i am looking at a method that adds a new line to add the label for corresponding group of records.

Heres what i am looking at:-

This is what my input file looks like:-

ABCDGroup_Label1234ABC1234ABC1234DEF1234DEF1234DEF1234GHI1234GHI1234GHI1234GHI1234JKL1234JKL1234MNO1234PQR1234PQR

Heres what i desire the output file to look like:-

ABCDGroup_LabelABC    1234ABC1234ABCDEF    1234DEF1234DEF1234DEFGHI    1234GHI1234GHI1234GHI1234GHIJKL    1234JKL1234JKLMNO    1234MNOPQR    1234PQR1234PQR

So basically keeping rest of table intact, only new rows with label of the Group of transactions below, to be introduced.

Any pointers towards this will be most helpful.

Regards,

New-Row-for-labels.xlsx

atcodedog05 · Accepted Answer

Hi @rohan146

Here is a workflow for the task. I am creating a blank row for each group and adding it back.

Hope this helps 🙂