Hi guys, please help. I have difficulty on this one.
I am dealing with hundreds of sheets
I want to transfer the data from multiple excel sheets (sheet.xlsx) into 1 excel file (monitoring.xlsx).
I already created a process on this one but it just outputs repeatedly everything.
This is my sample excel files. MONITORING.xlsx (202.1 KB) Sheet.xlsx (23.8 KB)
Activities panel → Merge datatable.
1st Datatable you read the range into the final datatable. Specify from which sheet you want to read and where the headers or the table start the read range cell.
Example if the headers start at the cell B6 read the range from it.