Data Arrangement

[tbobo]

I have this data file (about 2000 rows) all in column A:

data
A
B
C
D
data
1
2
3
4
data
D
E
F
G
data
5
6
7
8

I need a VB small program which will arrange the data with the follwin
format:


data A B C D
1 2 3 4
D E F G
5 6 7 8

Many Thanks

 

[Ardus Petus]

Are you sure your results should not be:

data A B C D
data 1 2 3 4
data D E F G
data 5 6 7 8

(which seems more logical)

Cheers,

 

[tbobo]

Yes, the data should be like what's shown below:

data A B C D
data 1 2 3 4
data D E F G
data 5 6 7 8

Thanks

 

[mrsinnister]

-This may seem like a beginner's question but here goes: I am trying t
sort dates starting with the weekday first; ex. Thursday, March 23
2006. However, when ever I sort it goes by alphabetical order by th
weekday and nothing else. I've tried reformatting the data, tha
didn't work, there's no formula that can change it and the DATE defaul
has a asterisk * by the correct format needed, meaning it doesn'
convert to my system. This project has to be done and functiona
today. Any help is appreciated.