Merging multiple rows into a single row

I have a spreadsheet that lists all customers and order numbers, with each order number having a different line, and the customers shown multiple times.

I would like to merge this, so each customer number is shown once, and the order numbers shown in the following cells. I've attached an example sheet.

I've seen various methods explained, but can't figure them out, so I'd appreciate an example if anyone can help.

Cheers

Baz

Thanks Marcol

I've not been able to get the macro working. I've not really used them before.

Is there any chance you could apply it to the spreadsheet I attached so I can see how it works?

I really appreciate your help with this.

That was the spreadsheet you attached.

The only differences were that
.
1/. I asumed that your headers were in row 1 in your real worksheet, and data began in row 2.
2/. I added a few lines for testing purposes

If this is not the case, please post a sample sheet, that clearly shows the sheet structure you are using.

I will be happy to help from thereon, and give any explanation you might need.

Cheers

i have a similar problem with the one above.

can anyone help me to achieve the result that is in the file attached.

regards,
sebastian

probebun.xls

Hi sensey1

Welcome to the forum ...
Read this Forum Rules before the moderators get you...

Forum Rules

2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread.

This thread is nearly 2 years old!

If you can Edit/Delete your post, do so, if not you'll need to ask a moderator to help you.

Cheers