Convert lines to columns - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Convert lines to columns

geogrgeogr greecePosts: 0Member

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

Sign In or Register to comment.