Re: Excel concatenate duplicate rows

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

Any chance I could get a sample of the code that would do this?

Mike

"Don Guillett" wrote:

Doable with a list (a macro can make it) and then a macro to loop thru and
append to the list. Easier to code
if less than 10. You could do it either way show below.

Server1,Serial#,OS,BIOS, Ver, NIC1,NIC2,NIC3
Server1,Serial#,OS,BIOS, Ver, NIC1,2,3
--
Don Guillett
SalesAid Software
dguillett1@xxxxxxxxxxxxx
"MFelkins" <MFelkins@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7993D416-477F-4FAC-B433-B9F2451FF245@xxxxxxxxxxxxxxxx
Hi,

I get a report from Dell OMSA that list all my dell servers and the
hardware
and firmware versions. The report lists each server in a row with its
attributes to the right. So far, so good. If the server has multiple NIC's
it
will create a row for each NIC. So I can have multiple entries for each
server, only differing in the NIC column. What I want is one row per
server.
If there are multiple NIC's or other hardware, I want that information
tacked
onto the end of the row. And duplicate information ignored.

Sample Rows

Server1,Serial#,OS,BIOS, Ver, NIC1
Server1,Serial#,OS,BIOS, Ver, NIC2
Server1,Serial#,OS,BIOS, Ver, NIC3

Desired output

Server1,Serial#,OS,BIOS, Ver, NIC1,NIC2,NIC3, etc

Any ideas?

Mike





.

Relevant Pages

  • Re: Excel concatenate duplicate rows
    ... "Don Guillett" wrote: ... Sub GetNICS() ... The report lists each server in a row with its ...
    (microsoft.public.excel.programming)
  • Re: Async and single threading sockets in SBCL
    ... > with multiple threads unless you have multiple CPUs and you know what ... > I've written single-threaded servers that support multiple connections ... I wanted to implement such a server that was free ... in particular it conses 3 new lists of that size. ...
    (comp.lang.lisp)
  • Re: Excel concatenate duplicate rows
    ... Sub GetNICS() ... The report lists each server in a row with its ... So I can have multiple entries for each ...
    (microsoft.public.excel.programming)
  • Re: Excel concatenate duplicate rows
    ... Doable with a list (a macro can make it) and then a macro to loop thru and ... The report lists each server in a row with its ... If the server has multiple NIC's ...
    (microsoft.public.excel.programming)
  • RE: Three Errors on Server 2003 SB Any idea?
    ... occurring on your SBS 2K3 Server: ... expand the Recipients object -> Offline ... Address Lists. ... Ensure a valid Public Folder Store is set for the Offline Address ...
    (microsoft.public.windows.server.sbs)