Hello,

I have a table containing the documents in each box.
In sheet1,
For example, In A1 there is box number 1 and in B1 "photos".
In A2 there is box number 1 and B2 "letters"
In A3 there is box number 1 and B3 "papers"
In A4 there is box number 2 and B4 "letters"
In A5 there is box number 2 and B5 "photos"

I want to run a macro that paste all the boxes in sheet2:
In A1 I want box number 1 and in B1 I want to concatenate
"photos"&"letters"&"papers"
In A2 I want box number 2 and in B2 I want to concatenate
"letters"&"photos".

The thing is I want to show 1 box per row on sheet2 with datas from sheet1

Thanks.