Forum Discussion

johnsboxftm's avatar
johnsboxftm
Brass Contributor
Apr 20, 2023

Help with consolidation

Hi, I would like to consolidate data from several columns that have multiple rows with counts and duplicate item numbers.   I have something likes this:   A               B                 C      ...
Formulas and Functions
Lorenzo's avatar
Lorenzo
Silver Contributor
Apr 21, 2023

Hi johnsboxftm 

 

Next time(s) please provide: Excel version + OS (Windows, Mac...) - Thanks

 

In attached file 3 options:

- Power Pivot (Excel >/= 2013/Windows)

- Power Query (Excel >/= 2016/Windows)

- Excel 365 dynamic array

  • johnsboxftm's avatar
    johnsboxftm
    Brass Contributor
    Apr 21, 2023

    Lorenzo 

    My apologies, it's Office 2021 and Windows.

     

    Here is a copy of the .xlsx.  There is nothing sensitive in it, it's just a bunch of Lowe's receipts organized by date, item number, unit price and description.

    • Lorenzo's avatar
      Lorenzo
      Silver Contributor
      Apr 21, 2023

      johnsboxftm 

      There are 10 sheets in your workbook

      - Which one contains the data you want to consolidate?

      - Any pref. between a Power Pivot or Power Query solution?

      • johnsboxftm's avatar
        johnsboxftm
        Brass Contributor
        Apr 21, 2023
        Whatever is the simplest to learn, haha. And Sheet 3, Columns B, C, D & E to the last row of 260. Sorry, I actually sent you the wrong sheet I had a less messy one. Thank you so much for your help!

Resources