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
edited August 2014 in VBA

I want to convert lines to columns. The data are in a csv file but I can import them to a sheet 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

Please also consider code for the case that there is a single action for every id and I only want (ID,ACTION,TIME=only1)

can anyone help?
Please note that I can code in Delphi and use Access to use if there is another way around

thanks,
George

Sign In or Register to comment.