Forum Discussion
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.
@Clint Hill
The file contains equivalent solutions in both Power Query and Excel 365 Lambda functions.
Example files are worth millions!!! Thanks Peter!