Convert lines to columns

geogr

I want to convert lines to columns. The data are in a csv file and the layout is

ID ACTION TIME

100 01 06:03

101 01 08:03

102 01 11:03

102 02 16:06

100 02 19:00

100 02 19:04

the result I want is either

ID ACTION TIME TIME

100 01 06:03

101 01 08:03

102 01 11:03

102 02 16:06

100 02 19:00 19:04

or (i can have actions seperate) so for the Action 02

ID TIME TIME

100 19:00 19:04

102 16:06

data can be imported to Access DB, Grids, ordered by field etc.
can anyone help?

thanks, George