GooberTron
Board Regular
- Joined
- Oct 13, 2012
- Messages
- 218
Where I have similar table layouts that need transformations within the same Excel file, I'm struggling to see how I can apply the same kind of logic as the "combine files" approach (i.e. transform sample file, apply same steps to subsequent files and then append). Doing the "expand table" approach within the same file just leaves me with a big appended mess that seems impossible to successfully transform afterwards.
This could be similar tables spread across multiple worksheets (e.g. 1 table per worksheet), or today I was presented with 10 identical tables on the same worksheet, just stacked on top of each other separated by 2 blank rows each time.
Having 10 separate queries or simply re-saving the Excel workbook 10 times and manually editing out to 1 table per workbook doesn't feel satisfactory or scalable! Any tips on solving this problem?
This could be similar tables spread across multiple worksheets (e.g. 1 table per worksheet), or today I was presented with 10 identical tables on the same worksheet, just stacked on top of each other separated by 2 blank rows each time.
Having 10 separate queries or simply re-saving the Excel workbook 10 times and manually editing out to 1 table per workbook doesn't feel satisfactory or scalable! Any tips on solving this problem?