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