I asked this before but got now replies - trying again in a more simple form.
I would like to Input one row of data. The output I want is multiple rows of data with new columns.
Eg. if I put in
I’d like to output multiple rows like
Date/Category B/AmountB …
The output data would depend on rules based on the input Category.
The bit I can’t find any help on is how to get an output of multiple rows in an array, based on the input of one row of an array.
Can anyone guide me to the right operator that I can learn?