Hi, I have data in the following format.
- Header rows contain Company ID (column A) and Transaction ID (column B)
- Detail rows contain Line IDs (column C) and Amounts (column D)
- Company ID and Transaction ID are blank for detail rows
See screenshot of input:
Desired output:
(Ignore the different values in column D as I simulated the amounts with random values.)
Any recommendations on what nodes I can use to join the details from header rows (columns A and B) with the detail rows (columns C and D)?
Right now I am using Excel VBA but this would be difficult for other users who don’t understand VBA.