Forum Discussion
Solved
How to Combine Data in Multiple Lists Separated by Company Info in One Worksheet
From a customer-provided spreadsheet with multiple lists of items and with the same column headers on each list, the issue is that each list is separated by rows containing company and document info...
@Clint Hill
The file contains equivalent solutions in both Power Query and Excel 365 Lambda functions.
Hi there,
If each list has a unique ID it’s possible to append the data into one list. Perhaps this could be achieved in PowerBI or Access but if you prefer Excel it might make sense to create a new tab and a copy/paste customer data into it like a manual append. Just throwing ideas out there….
Kind regards,
Julie Bunavicz
If each list has a unique ID it’s possible to append the data into one list. Perhaps this could be achieved in PowerBI or Access but if you prefer Excel it might make sense to create a new tab and a copy/paste customer data into it like a manual append. Just throwing ideas out there….
Kind regards,
Julie Bunavicz
@Clint Hill
The file contains equivalent solutions in both Power Query and Excel 365 Lambda functions.
- Example files are worth millions!!! Thanks Peter!
