Data mapping from one list to another

Hello! I have a predicament I am trying to solve. I wrote out what I am looking for in the picture but basically, I have two lists.
Input A:
List with 4 pieces of data per branch, 7 branches.
Input B:
List with 99 branches, 7 of which have 2 pieces of data in each branch.

And my desired output is:
List with 99 branches, 7 of which have 4 pieces of data from input A, mapped in order of input B. I.e. first branch of A maps to first branch location of input B, but replacing the data with the 4 pieces of data from input A.

Any help getting me on the right track would be greatly appreciated.

no code


Rajeev.gh (14.5 KB)

1 Like

@Mahdiyar thank you very much

This worked fantastically! Have a coffee on me :wink:

1 Like