Forum Discussion
Consolidate Rows With Power Query
I'm trying to make a scheduling spreadsheet to keep track of tasks at work. I have access to a file with our finished products and the components that are required, which I am using to populate the r...
DylanG Although, I've never tried a pivot table on a 250K rows data set, such a table could handle the task. But since you already are using Power Query, it takes only three steps to achieve the same.
Both are demonstrated in the attached workbook.