Excel macro to combine cells from different rows based on value of another row

Does anyone have a macro (or some other Excel solution) to combine cells from different rows based on a sequential number from 1 to 25 in another row (while also concatenating a space between the merged cells). I have attached a sample spreadsheet with some data and a sample of the desired output. Thank you for your help in advance!

Hi
try this macro
select the cell where you want the concatenated data to start (eg A24 of the example you posted).

Please Login or Register  to view this content.

Thank you for your reply and for the code. I get the following output, but no data in the concatenated field:

1AAGRAY 116330 AA 2 1
2ABL74 114103 AB 2 1
3ABZBC 112868 ABOND 2 1
1ADB102 115981 ADB 3 1

Any ideas? I have access to Excel 2007 and 2010 at work if you think that would make a difference...

Hey, I got it. I added one line:

ActiveCell.Offset(0, 5).Value = txt

And it works perfect. Thanks again for your help!!

would this work if i have more than 5 columns to combile.. based on column A .. I might have 100 or 200 cells in Column F

@ harryisurs

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.