combining data with the same ID and the similar variables



I have a large data set (about 1000 rows long), but it actually refers to
only 160 IDs with several (common) variables for each.
Example:

ID Var1 Var2 Var3 Var 4 etc

1 Var1
1 Var3
2 Var2
2 Var3
3 Var1
3 Var4\

And I need it to look like:

ID Var1 Var2 Var3 Var 4 etc

1 Var1 Var3
2 Var2 Var3
3 Var1 Var4
etc.

I have played around with sort, filter and as many of the reference and
logic functions as I can wrap my head around but I can't get excel to combine
the rows with the common IDs so that the variables common to those IDs are in
one row. Any help would be amazing!
Andrew
.



Relevant Pages

  • Re: new intrusion detection system
    ... Format is more recent attempt at the common xml based ... towards a common reporting format. ... and another IDS Prelude-ids also offers this. ...
    (Focus-IDS)
  • Re: about common group & user ID space (PR kern/14584)
    ... > (thing "chown bin.bin foo", ... with the common ID space. ... with low IDs do have overlapping names, and IDs, the sysctl sets ... > do a more complex ID space transformations, ...
    (FreeBSD-Security)
  • Re: IDS Testing Method
    ... >> If it is snort, you can use sneeze.pl to generate alerts. ... Also the common ... >> not dropping packets. ... generate events on other IDS that do not ...
    (Focus-IDS)
  • Re: ILR005E PLPA PAGE DATA SET FULL
    ... >state that simply butting PLPA and Common up against one another will cause ... My comments in this post are based on observation of GTF-traced ASM channel ... and a DX specifying the extent of the other page data set on the same volume. ...
    (bit.listserv.ibm-main)
  • RE: ILR006E COMMON PAGE DATA SET FULL, OVERFLOWING TO PLPA DATA SET
    ... performance problems, the fact that all page I/O is going to the same ... ILR006E COMMON PAGE DATA SET FULL, ...
    (bit.listserv.ibm-main)

Loading