Forum Discussion
Is there an easy way to sort data per type in power query?
Hi, Can I sort data from the table on the left (type A & B mixed in one column)to to the table on the right each type has its own qty column?
ToddChitt
Super User
Super UserYou should do a PIVOT operation in Power Query. Do you have some other column in there so you don't get a full SUM