Row split in to multiple rows based on cell data

**bosuck** · 02-08-2011, 05:12 AM

Hello
I need to get my data off an inventory sheet to a oddly formatted second sheet.

I have data on a sheet including item name, item number, item color, and item count base on size (size is broken over multiple columns e.g. small, medium, large)

It need to be on sheet 2 with columns as item name, item number, item color, item count

Each row from sheet 1 is copied to sheet 2 but it gets tricky because rows need to be additionally duplicated based on presence of a size. And that size need to be appended to the item name.
item name column e.g.
name1
name1 | size | Large
name1 | size | X-Large

Additionally the size columns are totaled

TIA
I manually made a file with sheet1 being a basic sample of what i have and sheet 2 being the required formatting. Please see attached test xlsx

**bosuck** · 02-08-2011, 02:01 PM

**stanleydgromjr** · 02-08-2011, 03:35 PM

bosuck,

Welcome to the Excel Forum.

I assume that your raw data is on Sheet1.

Detach/open workbook ReorgData w1 w2 plus Sum - bosuck - EF763515 - SDG13.xlsm and run macro ReorgData.

**JBeaucaire** · 02-08-2011, 03:43 PM

This was what I came up with, sorry I got lost at work... heh.

Please Login or Register  to view this content.

**JBeaucaire** · 02-08-2011, 05:27 PM

Thanks for the feedback.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

**bosuck** · 02-08-2011, 05:30 PM

Thanks! it works perfect.
I need to try to review the code a bit because need to expand it a bit- i have additional columns after the size columns that just need to be repeated every time a row is made - the same as the 'item number' or 'item color' columns

Mahalo!!