Take values from one excel and put into another for multiple columns and duplicate rows

[Swara_Soni (Swara)]

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

output

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

Please help

[Nithinkrishna]

Hey @Swara_Soni,

Please check the output below. Hope this is expected.

Here the approach is to add all the column data from source to target sheet including duplicate rows. The logic works for any number of columns.

PFA - JoinDT.zip (13.7 KB)

Check Output_Solution sheet for output data.

Hope this helps.

Thanks