Tranpose data. Please help!

K

Kay Ree

Hello there. I need some help. I would like to transpose
my data from rows to columns. Below is an example.

Field1 field2 field3
Name john
Address xxx1
ZipCode 12345
City atlanta
State ga
Name jane
Address xxx2
ZipCode 12345
City nashville
State tn
Name alex
Address xxx3
ZipCode 12345
City sacramento
State ca
Name daniel
Address xxx4
ZipCode 48945
City san diego
State ca

Instead of field1 field 2 and field3, I would like the
columns to be Name Address ZipCode City State and the data
that follows to go under the column headings-- the norm.
Any ideas on how to accomplish this? Thanks in advance!
..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top