JOhnH
Touchdown! Greaser!
I have a text file that is one collum and about 16,000 rows. I have no control over the creation of the source file.
The rows are sequenced such that 8 rows make a record and repeat. Every other row/cell is blank.
Like this:
A1 [empty]
A2 Date
A3 [empty]
A4 Last Name
A5 [empty]
A6 First Name
A7 [empty]
A8 Comment
A9 [empty]
A10 Date
A11 [empty]
A12 Last Name
A13 [empty]
A14 First Name
A15 [empty]
A16 Comment
Can I reformat this such that each sequence of 8 Column cells is moved into 8 sequential Row cells?
A1 thru A8 would get moved to C1 thru J1
A9 thru A16 would get moved to C2 thru J2
etc
etc
The rows are sequenced such that 8 rows make a record and repeat. Every other row/cell is blank.
Like this:
A1 [empty]
A2 Date
A3 [empty]
A4 Last Name
A5 [empty]
A6 First Name
A7 [empty]
A8 Comment
A9 [empty]
A10 Date
A11 [empty]
A12 Last Name
A13 [empty]
A14 First Name
A15 [empty]
A16 Comment
Can I reformat this such that each sequence of 8 Column cells is moved into 8 sequential Row cells?
A1 thru A8 would get moved to C1 thru J1
A9 thru A16 would get moved to C2 thru J2
etc
etc