Forum Discussion
James0610
Jun 07, 2022Copper Contributor
Excel Data Formatting
Hi, I am trying to format a set of data produced from an estimating program. I am trying to find a quick way to group like items, DH001 are the same item so I would like the Order (Quantity) of like ...
Riny_van_Eekelen
Jun 08, 2022Platinum Contributor
James0610 Perhaps PowerQuery is what you need. See example attached where only the blue shaded range is used to create the green table.