How can I create nested table from text data? I assume that 2 repeat steps are needed but I don’t know how I should do that.
For sample data and report image, please find it below.
Data description
Column 1 to 2 → Company Code
Column 4 to 6 → Reagion Code
Column 8 to 11 → Order Number
Column 13 to 20 → Ship Date
Column 22 to 28 → Parts Number
Column 30 to 32 → Amount
Report Image