How to combine content of multiple cells into one cell

[friend11_6]

Hi.

I am trying to use mail merge to send out notification to employees on the details their expense claims had been processed for payment.

My database (pivottable) has a column that lists down all the expense claims document numbers and the total to be paid for all these expense claims added together. How do I create a formula to concatenate all the document numbers into one cell, given that the number of cells containing the document numbers vary from employee to employee? I have attached the file showing the format of my database (pivottable).

Thanks.

[JBeaucaire]

Care to post an example of the results you're looking for?

[friend11_6]

Hi.

I've added the results that I'm looking for in red bold of the attached file.

Any clue?

Thanks!

[JBeaucaire]

Run this macro with the pivot report sheet active:

Please Login or Register  to view this content.