I have a list of Supervisor Codes that I need to join into a single cell.

column A column B
272111 2011
272111 2056
272111 2059
272325 2056
272325 2058
275456 1125
275456 2056

column A New Column
272111 2011; 2056; 2059
272325 2056; 2058
275456 1125; 2056

Any help would be greatly appreciated!!

Thanks

Kathy