I have a spreadsheet that has multiple rows and two Colums. A1 =
Server name, B1 = email address of the server owner. The problem is
that servers have multiple owners so one server could have 7 rows.
What I would like to do is to concatinate all the email addresses, so
I have one row per server.
For example here is the existing data:
Row = Column1, Column2
Row 1 = Server1,
Row 2 = Server1,
Row 3 = Server1,
Row 4 = Server1,
Row 5 = Server2,
Row 6 = Server2,
Row 7 = Server3,

What I would like to have is:
Row 1 = Server1, ; ;
;
Row 2 = Server2, ;
Row 3 = Row 7 = Server3,

I am not familiar with macros, is there any way of doing this with
functions?