reformatting output to multiple rows and inserting blank rows as needed for import

I have generated output as shown in the 'before' section of the sample data, and would like to reformat this output if possible to the presentation in the 'after' section of the attached sample data. The 'after' format is required to import journal entries into our software system. I would like this formatting to apply at the end of my workflow each time it runs. The company number, Adj codes, number of accounts in each Adj, and 'Sum of Amount' will vary in each run. Is there a way to do this?

Thank you for your help!

SampleData.xlsx

Tips and Tricks

Accepted answers

SPetrie

I think this will do what you are asking or at least get you started.

I used a batch macro to take the companies one at a time. It splits out the first 3 columns and then just the first row, and adds a blank separator row.

It also splits out the remaining columns, and sandwiches it between additional separator rows to create the final output.

geraldo

@newsomesm

an example workflow of another way to build this layout

examplelayout.yxmd

All comments

SPetrie

I think this will do what you are asking or at least get you started.

I used a batch macro to take the companies one at a time. It splits out the first 3 columns and then just the first row, and adds a blank separator row.

It also splits out the remaining columns, and sandwiches it between additional separator rows to create the final output.

geraldo

@newsomesm

an example workflow of another way to build this layout

examplelayout.yxmd

newsomesm

thank you SPetrie, this is fantastic!

newsomesm

thank you Geraldo this works! It's great to have multiple solutions to a problem, thank you for including a sample flow, this makes it easy to implement!

SPetrie

I swore I added an example workflow to my response as well but apparently didnt. Sorry about that

example workflow.yxzp

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703