Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search and Combine Rows
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine: ISNUMBER(SEARCH( and EXACT( ? | Excel Discussion (Misc queries) | |||
How do I combine worksheets w/o enough rows to combine? | Excel Worksheet Functions | |||
Search For Multiple Entries - Combine and Sum | Excel Programming | |||
vlookup and search combine in vba. | Excel Programming | |||
vlookup and search combine in vba. | Excel Programming |