Hi
I need a little help, or a VBA script that can convert a quite big dataset (960000 rows) in the format like below.
All the data are in one column.
The number of rows vary for each trip_id, from a few to several tousands. The number og columb is the same, 6 in all.
I would like to convert the data into multiple columns, one column for each TRIP_ID, like this:
And so on, I have around 1800 TRIP_ID's. I would like a few empty columbs between each trip_id range.
In short terms i would like to, Convert from one long column, to multiple columns based on TRIP_ID
I need a little help, or a VBA script that can convert a quite big dataset (960000 rows) in the format like below.
Code:
TRIP_ID | OBJECTID + (4 more columns )
2626 | value
2626 | value
64646 | value
64646 | value
13455 | valueAll the data are in one column.
The number of rows vary for each trip_id, from a few to several tousands. The number og columb is the same, 6 in all.
I would like to convert the data into multiple columns, one column for each TRIP_ID, like this:
Code:
TRIP_ID |(+5 columns) | | TRIP_ID | (+5 columns)| | TRIP_ID | ..... | And so on for 1800 trip_id's
2626 | (+5 columns) | | 64646 | (+5 columns) | | 13455 | ..... |
2626 | (+5 columns) | | 64646 | (+5 columns) | |And so on, I have around 1800 TRIP_ID's. I would like a few empty columbs between each trip_id range.
In short terms i would like to, Convert from one long column, to multiple columns based on TRIP_ID
