+ Reply to Thread
Results 1 to 2 of 2

Need help creating and consolidating a pivot table

  1. #1
    Registered User
    Join Date
    06-15-2015
    Location
    WV
    MS-Off Ver
    2013
    Posts
    17

    Need help creating and consolidating a pivot table

    Take a look and see if you can help me create a better table and also a pivot table.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Need help creating and consolidating a pivot table

    Your data is inconsistand.

    row 45 - 48

    In the other rows you have first the name and in the row below the text "vin".

    VIN# YEAR TYPE EQUIP SERIAL NUMBER MODEL
    CAT0420DCFDP02746 2004 CAT LOADER/BACKHOE 7BJ54732 420D

    BACK HOE #1
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Consolidating data with a chart or pivot table
    By ehitt in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-24-2013, 11:08 PM
  2. Consolidating Pivot Tables into 1 pivot table - is this possible?
    By levitt in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-20-2013, 04:10 PM
  3. [SOLVED] Consolidating Pivot Table criteria
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-26-2012, 05:11 PM
  4. Consolidating data for pivot table
    By floricita in forum Excel General
    Replies: 0
    Last Post: 09-01-2010, 09:03 AM
  5. Replies: 3
    Last Post: 10-26-2009, 01:39 PM
  6. Consolidating data in one Pivot Table.
    By Kianuz in forum Excel General
    Replies: 2
    Last Post: 10-23-2009, 10:24 AM
  7. [SOLVED] Consolidating multiple external pivot tables into one pivot table
    By Exiled in forum Excel General
    Replies: 1
    Last Post: 08-13-2006, 07:51 AM
  8. Pivot Table - consolidating ranges (again)
    By xman in forum Excel General
    Replies: 3
    Last Post: 09-18-2005, 10:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts