Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rows to Columns
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, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rows to Columns
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 "FJinSA" wrote in message ... 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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rows & Columns in Excel | Excel Worksheet Functions | |||
convert columns to rows & rows to columns | Excel Discussion (Misc queries) | |||
How to swap rows and columns? | Excel Discussion (Misc queries) | |||
hidden rows & columns slow file open | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) |