Consolidate Rows With Power Query

Question

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 required tasks to be done. Basically, it is formatted as:

Finished Good	Component	Cut Cable	Cut Wire	Cut Shrink1	Cut Shrink2
1111	Cable	x
1111	Wire		x
1111	Heat Shrink1			x
1111	Heat Shrink2				x
2222	Wire		x
3333	Wire		x
3333	Heat Shrink2				x

My desired output is:

Finished Good	Cut Cable	Cut Wire	Cut Shrink1	Cut Shrink2
1111	x	x	x	x
2222		x
3333		x		x

What is the best way to achieve this? I have simplified this a lot, and not all components have a required task associated. The file I am using has around 250K rows.

Thanks

riny_van_eekelen · Answer

DylanG&nbsp;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.&nbsp;Both are demonstrated in the attached workbook.

Forum Discussion

Consolidate Rows With Power Query

1 Reply

Resources