StrangeLuck
New Member
- Joined
- Mar 25, 2002
- Messages
- 15
Let's say I have a large group of data like this:
12:00 AM 4
12:00 AM 7
12:00 AM 34
12:00 AM 3
12:30 AM 31
12:30 AM 4
12:30 AM 4
12:30 AM 7
with multiple values for each time. How can i get the data to look like this:
12:00 AM 4 12:00 AM 7 12:00 AM 34, etc?
In other words, I want the large column of data split into eight columns whereby columns 1,3,5,7 would be the dates and 2,4,6,8 would be the data. Any ideas?
12:00 AM 4
12:00 AM 7
12:00 AM 34
12:00 AM 3
12:30 AM 31
12:30 AM 4
12:30 AM 4
12:30 AM 7
with multiple values for each time. How can i get the data to look like this:
12:00 AM 4 12:00 AM 7 12:00 AM 34, etc?
In other words, I want the large column of data split into eight columns whereby columns 1,3,5,7 would be the dates and 2,4,6,8 would be the data. Any ideas?