+ Reply to Thread
Results 1 to 4 of 4

Table Configuration Re-Arrangement

  1. #1
    Registered User
    Join Date
    01-19-2019
    Location
    Mexico
    MS-Off Ver
    2016
    Posts
    4

    Table Configuration Re-Arrangement

    Hello All,

    First of all, thanks to anyone who reads this post, I have come across another task that I have not been able to solve and I would really appreciate any suggestion that could led me to the solution of this issue.

    To the issue:

    In my work I have a big database with improper configuration, actually I have several of this databases. But the configuration that it has it's not compatible with some software in which I need to upload the information (I do not have access to that software).

    It is a little bit hard to post the example in here so I attach the excel file with the example of what I want in the sheet called: (Target Configuration). And one of those complete databases also included on the file.

    Again thanks to all!
    Attached Files Attached Files

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Table Configuration Re-Arrangement

    You can use Power Query (Get & Transform Data).

    Format your source data as a table, then use:

    Please Login or Register  to view this content.


    I've truncated your sample data in the attached workbook, to reduce the file size.
    Attached Files Attached Files
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    01-19-2019
    Location
    Mexico
    MS-Off Ver
    2016
    Posts
    4

    Re: Table Configuration Re-Arrangement

    Thanks Olly,

    At this moment I am trying to understand this option, I am not familiar with it but I will dig into it enough to fully understand it.

    Just a simple question. Column J in the table I attached is the most important information I need, column D is a process name, and column J is the circuits that make up the process. Would you mind adding that in your file and explanation?

    Thanks a lot!

  4. #4
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Table Configuration Re-Arrangement

    Just play around with the reordering of the column names:

    Please Login or Register  to view this content.
    Last edited by Olly; 10-28-2019 at 05:53 PM.

+ 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. Configuring a pivot from an unknown configuration to desired configuration
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-10-2015, 11:14 AM
  2. [SOLVED] Pivot table arrangement
    By Mroy in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-11-2013, 06:14 AM
  3. [SOLVED] Table Arrangement
    By atlant15 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-06-2013, 03:07 AM
  4. [SOLVED] Need to change a table arrangement
    By D J in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-03-2013, 12:51 PM
  5. Pivot Table Arrangement
    By seanyc in forum Excel General
    Replies: 1
    Last Post: 06-25-2012, 08:25 AM
  6. Pivot table arrangement
    By kisboros in forum Excel General
    Replies: 0
    Last Post: 01-16-2012, 08:33 PM
  7. Excel 2007 : Pivot Table Configuration
    By thegenerallee in forum Excel General
    Replies: 1
    Last Post: 09-26-2009, 02:00 AM

Tags for this Thread

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