Maybe something like this:

assuming
John Doe is in A2
Wall St is in B2
1234567 is in C2
and you have the numbers from 1 to 24 in row A6 then:

=IF(LEN($A2&" "&$B$2&" "&$C2)=A6,MID($A2&" "&$B2&" "&$C2,A6,1),"")
copied across and down
or you if you don't have a numbered row then you can use the column function
instead
=IF(LEN($A2&" "&$B2&" "&$C2)=COLUMN(A1),MID($A2&" "&$B2&"
"&$C2,COLUMN(A1),1),"")

HTH
JG

"Jahcureus" wrote:

I have a file with column headings for name, address, account.
For Example

Name Address Account
John Doe wall st 1234567

I want to put it in a format that displays like this:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
21 22 23 24
D O E J O H N W A L L S T 1 2
3 4 5 6 7

Numbers (1-24) represent position in file, I am extract info from an excel
file and putting it in a format the has column (1-52) that single out the
info. As I said i dont know if this is possible