Rows to Columns

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

Guest

Hi, Need help converting data on a spreadsheet which is layout across a row,
for example, I have Sunday thru Saturday by employee, but I need to upload to
an access table by date. so can I convert data from rows to colums and then
import that data to access?
Thanks,
 
Copy the data.

Select another area on the sheet that does not overlap the original data

Then: Edit | PasteSpecial | Transpose

Delete the original data

Regards

Trevor
 
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

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Sum Days into Weeks 1
VBA - retrieve data on last create named range from previous inserted named range 0
Need to alphabetize data from separate cells within same row 2
Multiple measures in MS Access pivot table-Sigma Value in Row not Column 0
convert columns to rows 6
Link an entire Row with a Key Word 1

Back
Top