Excel 2007 : Creating rows from data that is spread across multiple columns.

[ExcelWorkerNeedsHelp]

I have data in the following format.

Title 1 Item 1 Item 2 Item 3 Counter
---------------------------------------------------------------
A Z X 2
B Z 1
C Z X Y 3

I would like to convert this data to a format that shows the "Title 1" repeated on [Counter] number of rows with each "Item" listed beside it. Such that the end product is as follows:

Title 1 Item
---------------------
A Z
A X
B Z
C Z
C X
C Y

Does anyone have a solution to this? Please let me know if you need more information.

Thanks.

[stanleydgromjr]

ExcelWorkerNeedsHelp,

Detach/open "Creating rows from data that is spread across multiple columns - ExcelWorkerNeedsHelp - SDG10.xls" and run macro "ReorgData".

[ExcelWorkerNeedsHelp]

Thank you, Stan!!

Unfortunately I do not have a experience with VBA so any comments you can provide for your posted Macro would assist me in re-writing it to suit the needs of my data. In essence, my data contains over 800 "Titles" and about 35 Items.

Once again, I appreciate your assistance.

[ExcelWorkerNeedsHelp]

FYI all - SLASHSMF is a bot that is pasting the same URL on other users posts.

[stanleydgromjr]

ExcelWorkerNeedsHelp,

Please post your workbook.

Click on New Post - then scroll down and see Manage Attachments.