I am having two excel sheets multiple scenerio.xlsx (11.8 KB) all data for assign that contains the base data where to take values from and assign to sheet where to assign data and output the required output sheet
all data for assign
assign to sheet
I used lookup data table for the same but it is not assigning values to duplicate rows.
The values to assign in data table has multiple columns as well as duplicate rows