I have a little bit of complicated excel attached.
What I want to do is read all the data from all the sheets and create a new excel with all the rows.
So in the final excel sheet, there will be 22 records.
2 issues here:
- Some columns are associated with multiple rows example “Brand”
- The Sheet name are always different so sheet name should not be hardcoded.
ExlSheet.xlsx (14.5 KB)