Table reformat

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

Hello,

Using either Excel or Access I would like to try and format the following
data in an automated way:

Name | type
joe a
john b
joe b
jack c
joe c


shown as

name | type1 | type2 | type3......
john b
joe a b c
jack c

Tried manual formatting but its too slow for the size of file I will be
needing it for.

Any help would be very much appreciated

T
.

Relevant Pages

  • Re: "Invalid Media Format" error
    ... Joe H. Gallagher wrote: ... : John F wrote: ... :> Format" for both commands, ... The disks are recognized okay using sh dev, ...
    (comp.sys.dec)
  • Re: Separate TEXT
    ... I typed "John A. Doe" into A1, then used the formulas provided in the post ... > Joe). ...
    (microsoft.public.excel.worksheet.functions)
  • query to locate which record was not added
    ... jim, jack, joe, and john. ... Jack forgot to turn in his report* ...
    (microsoft.public.access.queries)
  • Re: Solution Manual and Test Bank
    ... Jack C. McCormac ... Michael Meyer,Eric J. Miller ... John G. Proakis,Dimitris K Manolakis ... William J. Palm III ...
    (sci.math.num-analysis)
  • Re: Solution Manual and Test Bank
    ... Jack C. McCormac ... Michael Meyer,Eric J. Miller ... John G. Proakis,Dimitris K Manolakis ... William J. Palm III ...
    (sci.math.num-analysis)