|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
Search and Combine Rows
On 27/03/2012 2:20 AM, ktemplin wrote:
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?
Row = Column3
=Column1&","&Column2
HTH
Mick.
|