Break up Record

Hi,
I have a table with only one record in it looks someting like this
Field Titles : Name Address PC
Data : Bert A House CL4
Is it possible to reformat this so that it looks like
Name
Bert
Address
A House
PC
CL4
Usually I am doing this the other way around and moving things up onto one
like, it's been a long morning not much fun being in work at 6.40am so any
help would be brilliant.
Thanks Phil, zzzzzzzzzzzzzzzzzzDont worry about this post, I have woken up and managed to sort it.
Thanks Phil
"Phil" wrote:

> Hi,
> I have a table with only one record in it looks someting like this
> Field Titles : Name Address PC
> Data : Bert A House CL4
> Is it possible to reformat this so that it looks like
> Name
> Bert
> Address
> A House
> PC
> CL4
> Usually I am doing this the other way around and moving things up onto one
> like, it's been a long morning not much fun being in work at 6.40am so any
> help would be brilliant.
> Thanks Phil, zzzzzzzzzzzzzzzzzz