colums and rows ...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 Edit>Copy
Select a starting cell to paste the data (e.g. Sheet2!A1)
Choose Edit>Paste Special
Select Transpose, click OK
 
You must log in or register to reply here.

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

SUMIF and multiple criteria 3
Excel Help to copy information from one row at a time to another sheet 1
Linking Rows instead of just cells. 1
merge excel into word and email 1
copy and past cells found by SUMPRODUCT 1
Conditional Formula with Words and different columns 5
how to keep the total colum 5
Parsing Information from a Cell 3

Back
Top