I have got a issue and need some help. I have a sheet as follows:

Sector BR CC TCH_List
1 1 1113
1 2 329
1 3 1153
1 4 1155
1 5 1157
2 1 823
2 2 115
2 3 9
3 1 1145
3 2 817
3 3 789
3 4 1013
3 5 797

Finally, I want have a sheet like this:

Sector BR CC TCH_List
1 1 1113 1113;329;1153;1155;1157
2 1 823 823;115;9;1145
3 1 1145 1145;817;789;1013;797

I need all the CC column with the same sector value go to the TCH_list and
separate with ";". and just BR=1 rows are kept.

my question is: is there any macro or formula could be used for such a
request?

thank u.