Iterative Macro Help

[josiahgoh]

Hi, i have the following dataset in the picture attached, where i need to transform the records into the following output as attached, group by the different categories.

I would like to ask how can i make use of an iterative macro to do that. I have attached a workflow for reference.

Kindly seek your advice on this.

[aatalai · Accepted solution]

@josiahgoh managed to get what you are looking for but with a batch macro rather than iterative, hope it helps.

[josiahgoh]

Hi @aatalai thanks for this. This is awesome.

Can i ask how can i enhance the workflow to include different number of L rows per category found in the new attachments?

[aatalai · Accepted solution]

@josiahgoh see attached, hope it helps  

[josiahgoh]

Thanks. It helps.