Hi everyone,

This is my first post, so... here it goes :-)

I have a workbook with two sheets and every sheet has its own table. Both tables contain 2 columns.
Table 1 (columns A and B on sheet1)
Nr ReasonCode
1 AAA
2 BBB
3 EEE
4 AAA
5 CCC
etc...

The other table (table2 on sheet2 columns A and B) needs to contain the same data only in a kind of transposed view. Like...
ReasonCode Nr
AAA 1,4
BBB 2
CCC 5
DDD
EEE 3
FFF
etc

So in short: I am looking for a routine to conditionally concatenate the sequence numbers into table2. Important is that when a reason code is used multiple times, these sequence numbers are added to the same cell.
I will run this macro when activating SHEET2 in the Private Sub Worksheet_Activate() section

Thanks for the help ;-)