i have one excel file with 3 Sheets.
Raw= Raw Data with multiple columns and rows
updateColumn = With all the columnNames of Raw Data and Default Value
Output= Output Sheet
i would like to know how to update the column Values of Raw data as per the default value
mentioned in the UpdateColumn.
without using for each row. as the Raw data consist of 50K line items.
please check the sample output for reference.
Excel.xlsx (14.2 KB)