| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find rows for unique data in 1 column and different data in other. | Excel Discussion (Misc queries) | |||
| How do I name the colums and rows? | New Users to Excel | |||
| switch colums and rows | New Users to Excel | |||
| Rows and columns | New Users to Excel | |||
Linear Mode
