+ Reply to Thread
Results 1 to 6 of 6

Change data structure using Formula or Power Query ( Get & Transform)

  1. #1
    Forum Contributor
    Join Date
    07-12-2015
    Location
    Dubai,UAE
    MS-Off Ver
    2007,Office 365
    Posts
    352

    Change data structure using Formula or Power Query ( Get & Transform)

    Hi,

    I need to restructure the data in an existing table as shown in the attached file.
    Im trying to find a formula solution and if possible an alternative using Power Query also
    Thanks in advance

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    10,621

    Re: Change data structure using Formula or Power Query ( Get & Transform)

    is that what you want?
    sandy
    Learn Power Query (XL2010/2013 require PQ add-in)
    I want to see what you are trying to achieve, not how you are trying to do it
    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  3. #3
    Forum Contributor
    Join Date
    07-12-2015
    Location
    Dubai,UAE
    MS-Off Ver
    2007,Office 365
    Posts
    352

    Re: Change data structure using Formula or Power Query ( Get & Transform)

    Hi sandy,

    This does the job!!

    Overlooked the pivot tables...

  4. #4
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    10,621

    Re: Change data structure using Formula or Power Query ( Get & Transform)

    Glad to help

    If problem is solved mark thread as SOLVED (scroll up, thread tools, Mark Thread as SOLVED)

    Thanks for rep

  5. #5
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2010
    Posts
    3,049

    Re: Change data structure using Formula or Power Query ( Get & Transform)

    You can also do by formula.
    Look attach file.
    In summary sheet extract unique name from sheet1
    Accordingly revision number "submit" & "return" Date extract by formula index match.
    In sheet1 add helper column. "E" also create table in case in future add data in sheet1 auto pull down in summary sheet.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  6. #6
    Forum Contributor
    Join Date
    07-12-2015
    Location
    Dubai,UAE
    MS-Off Ver
    2007,Office 365
    Posts
    352

    Re: Change data structure using Formula or Power Query ( Get & Transform)

    Thanks avk!!

+ 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. Power Query Formula/Syntax
    By mielkew27 in forum Excel General
    Replies: 2
    Last Post: 04-09-2017, 11:44 PM
  2. Get & Transform (Power Query) not showing certain tables
    By BamBamMoneyBags in forum Excel General
    Replies: 0
    Last Post: 03-22-2017, 12:22 PM
  3. [SOLVED] Transform table to database structure
    By p3rlend in forum Excel General
    Replies: 4
    Last Post: 09-23-2016, 02:49 PM
  4. How do I get my formula to work in a power query
    By Justair07 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-22-2016, 10:34 AM
  5. [SOLVED] Formula Creation with Power Query
    By Bhalbert in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-05-2016, 01:11 PM
  6. Replies: 0
    Last Post: 11-14-2012, 03:52 PM
  7. Change orientation of data - is this a transform?
    By Angus Comber in forum Excel General
    Replies: 2
    Last Post: 02-16-2006, 09:20 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