Excel Column/Row reversed

R

Ron Carr

I am trying to help a non-profit convert spreadsheet data to Access 2003.
Their spreadsheet data is reversed from what I would like (!), in that the
per-person data is in separate columns, and the field names are in each row!
Is there any easy way to import this stuff, or do I start coding.....
There are over 200 fields: collecting data for Government!!
Thanks!
 
K

Klatuu

Not a problem. open the workbook that has the data in it you want. Create a
new sheet, Select all the data. Do Copy, Paste Special-Transpose into the
new sheet. The transpose makes all the columns rows and all the rows
columns. Now it is in the form you would like (!).

Or, just turn you monitor on it's side, and it should look fine.
 

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

Need help merging Excel into Publisher Booklet w 2 columns 0
Linking data in MS Word into Excel 5
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Mail Merge query 1
Merging from an Excel file with graphics 1
convert columns to rows 6
Excel to Word to PDF workflow 1
200 COL Excel file with 700 rows -how to switch COLS & ROWS in ACC 2

Top