+ Reply to Thread
Results 1 to 2 of 2

Unpivot Data with multiple headers grouped

  1. #1
    Registered User
    Join Date
    06-16-2016
    Location
    Carson, CA
    MS-Off Ver
    Professional Plus 2013
    Posts
    1

    Unpivot Data with multiple headers grouped

    Hi All,

    I have a set of data that I am working on a macro to unpivot. Each individual “item” has multiple columns of information (i.e. Style #, Description, Color, and Size). I want the headers to remain as they are and keep the individual item information together, but I want each item to be on its own row (i.e. Jane Doe item 1 is on row 2, Jane Dow item 2 is on row 3, John Doe item 1 is on row 4, John Doe item 2 is on row 5, etc.).

    Please have a look at the data below as an example of what I am trying to achieve. Any insight and help is greatly appreciated!

    INPUT
    ID First Name Last Name Style 1 Description 1 Color 1 Size 1 Style 2 Description 2 Color 2 Size 2
    1001 Jane Doe 1234 Jean Dark Denim 2 5678 Sweater Navy S
    1002 John Doe 5544 V Neck Green L 5544 V Neck White L
    1003 Jack Doe 6845 Belt Black M 5544 V Neck Black M
    1005 Jennifer Doe 3456 LBD Black M 1234 Jean Dark Denim 8


    DESIRED OUTPUT
    ID First Name Last Name Style 1 Description 1 Color 1 Size 1
    1001 Jane Doe 1234 Jean Dark Denim 2
    1001 Jane Doe 5678 Sweater Navy S
    1002 John Doe 5544 V Neck Green L
    1002 John Doe 5544 V Neck White L
    1003 Jack Doe 6845 Belt Black M
    1003 Jack Doe 5544 V Neck Black M
    1005 Jennifer Doe 3456 LBD Black M
    1005 Jennifer Doe 1234 Jean Dark Denim 8

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Unpivot Data with multiple headers grouped

    http://datapigtechnologies.com/blog/...data-explorer/
    http://datapigtechnologies.com/blog/...data-explorer/

    Those can likely do what you want, using PowerQuery which is a free add-in FROM Microsoft (which used to be called Data Explorer).
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

+ 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. Unpivot Data
    By naveeddil in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-07-2015, 08:04 AM
  2. Unpivot and stack data
    By yching in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-14-2015, 05:18 AM
  3. Creating a time series from data grouped in months for multiple years
    By nzi0001 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-13-2014, 03:21 PM
  4. Unpivot Data
    By Olly in forum Tips and Tutorials
    Replies: 0
    Last Post: 04-02-2014, 05:33 PM
  5. Page headers in grouped sheets
    By HoThereSmallFry in forum Excel General
    Replies: 1
    Last Post: 09-20-2013, 01:55 AM
  6. Need 'unpivot' help for attached spreadsheet data.
    By ReneeM787 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-09-2012, 12:21 PM
  7. Converting grouped data in multiple rows and columns to single row
    By learner_123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-23-2012, 05:49 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