colums and rows ...
 

How can I get change column A to become field names and column B to file the
information into the correct fields in each column?

You can transpose the data, if you don't have more than 256 rows of data:

Select the data
Choose EditCopy
Select a starting cell to paste the data (e.g. Sheet2!A1)
Choose EditPaste Special
Select Transpose, click OK

Star wrote:
How can I get change column A to become field names and column B to file the
information into the correct fields in each column?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html