+ Reply to Thread
Results 1 to 2 of 2

Transforming data without Power Query

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,946

    Transforming data without Power Query

    I have multiple files that are sent to me on a monthly basis. They're laid out with End of month dates to the left, then an unneeded "Days in Month" column, then tons of different headers, with values underneath. Each file has a tab laid out the same, one for Days, one for FTEs, one for Cost. I don't have access to Power Query, but we will be moving up to Excel 2016 in a few months, so need something in the meantime.

    So, for each of about 20 different files each month I would like to bring the values from all three sheets into one sheet with Five columns:
    1) Placement -this is the header values
    2) Month-Yr (beginning of month, though data reflects End of month)
    3) Days
    4) FTEs
    5) Cost

    I've attached a sample workbook. I'm thinking there should be a simple lookup formula I can use to bring in my values, but so far I'm not having luck trying an index/match route. Any help would be appreciated.
    Attached Files Attached Files
    I know I'm not stupid, but I suspect I'm a lot stupider than I think I am

  2. #2
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    3,946

    Re: Transforming data without Power Query

    I figured it out. Index/Match wasn't what I needed, but instead Vlookup/Match, as in
    Please Login or Register  to view this content.
    where C1352 is "9/1/2015" and B1352 is "Basic PRS IVE".

+ 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. error in power query & power pivot
    By Baldev Kumar in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 01-03-2018, 01:34 AM
  2. Dropbox Data Host/Source for Power Query
    By mielkew27 in forum Excel General
    Replies: 0
    Last Post: 04-09-2017, 11:49 PM
  3. Power Query - Add dates to fixed Data set
    By happydays886 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-17-2017, 10:40 AM
  4. Denesting tables in XML data imported into Power Query
    By Cuine100 in forum Excel General
    Replies: 1
    Last Post: 08-11-2016, 09:30 PM
  5. Adding data to the end of a table with Power Query
    By afila in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-14-2016, 08:29 AM
  6. Power Query - Get external data from Folder
    By crainaud in forum Excel General
    Replies: 0
    Last Post: 03-24-2016, 12:49 PM
  7. Power Query Import Binary Data Type
    By brent_milne in forum Excel General
    Replies: 0
    Last Post: 08-13-2015, 09:46 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