Grouped Excel Data Processing

This workflow demonstrates how to process Excel data with multiple "tables" on a single sheet.

1. Read all data from sheet
2. Clean it up and group rows which belong to same table by adding GroupID column
3. Process each group using Group Loop
4. In each iteration prepare grouped data for unpivoting
4. Unpivot and concatenate data in Loop End

External resources

• Forum Topic