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
Bookmarks