Forum Discussion

TheProjectGuys's avatar
TheProjectGuys
Copper Contributor
Nov 27, 2024
Solved

Excel Help

Hi,

 

I have data which covers a number of customers and manufacturing dates however the part number is same. I would like to reduce each unique part number into one line but summing up the values in columns E, F & G.

I assume this can be done (I have 23k rows of data!)

Thanks.

I.

 

excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Nov 27, 2024

    Create a pivot table. Part number in the Row area. Completed, Planned and Forecast in the Values area. That should do it.

     

2 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Nov 27, 2024

    Create a pivot table. Part number in the Row area. Completed, Planned and Forecast in the Values area. That should do it.

     

Resources