+ Reply to Thread
Results 1 to 1 of 1

Consolidating data with a chart or pivot table

  1. #1
    Registered User
    Join Date
    09-24-2013
    Location
    Denver, Colorado
    MS-Off Ver
    Excel 2010
    Posts
    1

    Consolidating data with a chart or pivot table

    I am trying to consolidate data that is not able to be exported to excel in a clean column/row format. The order of the data changes on occasion and I need to be able to find a product price based on the supplier name. I would like to put this into a table format which will allow the information to flow into it despite the order in which the data is exported. I have attached an example of my data and the table that I would like to use with it.

    I thought about combining a vlookup and an hlookup, but the format does not seem conducive to these formulas.

    Any advice will help.

    Thank you!
    Attached Files Attached Files

+ 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 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
  2. [SOLVED] Consolidating Pivot Table criteria
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-26-2012, 05:11 PM
  3. Consolidating data for pivot table
    By floricita in forum Excel General
    Replies: 0
    Last Post: 09-01-2010, 09:03 AM
  4. Consolidating data in one Pivot Table.
    By Kianuz in forum Excel General
    Replies: 2
    Last Post: 10-23-2009, 10:24 AM
  5. [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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1