Results 1 to 3 of 3

Thread: Transpose cross-header table into a relational table

  1. #1
    Neophyte parahumanoid's Avatar
    Join Date
    Apr 2013
    Location
    A, A
    Posts
    3
    Articles
    0

    Transpose cross-header table into a relational table



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am looking for a native way (or a macro) that would take a table that has column headers and row headers and use those as cell values for new column1 and column2 while column3 would be filled with the cell values of the original table, thus yielding a relational DB-style table.

    Thanks a bunch, guys.
    Alex.

  2. #2
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    Are you wanting to unpivot a crosstabulated table?

    Can you post an example before and after shot, so your intent is clearer?

  3. #3
    Excel 2010, Tables, PivotTables, PivotCharts
    De-normalize an array with two levels of row and column headers.
    With macro.
    http://8936e6d9f85be098ae08-f26298a4.../07_09_12.xlsm
    If you get *.zip, don't unzip, just rename *.xlsm

Posting Permissions

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