Move rows data to some columns

[xcao]

I need to do some data manupalation for some staff. She wants to move part of the row data to column.
So I imported it as a table into Access.

It's a table that has multiple rows for one employee.
I would like to combine them into one row.

Please note is Not to move All rows into columns.

For example

EmployeeID, Firstname, Lastname, plan description, plan Category
ID1, John, Smith, Delta dental, Single
ID1, John Smith, Life insurance, Basic
ID1, John Smith, Long term disablity, 2/3Salary
ID2, Mary, Olson, Delta dental, family,
ID2, Mary, Olson, Preferred one, Single.

I would like to put each employee into one row.
For example:
EmployeeID, Firstname, Lastname, plan description1, plan Category1,plan description2, plan Category2, plan description3, plan Category3


ID1, John, Smith, Delta dental, Single, lifeinsurance, Basic, longterm disablity, 2/3 salary.

How can I do it?

Thanks a lot

 

[pbaldy]

Something along these lines could be adapted:

http://www.mvps.org/access/modules/mdl0004.htm