Saturday, February 23, 2013

How Do I Change Data in Vertical Columns to Horizontal Columns in Excel or Access?


Transposing Data in Excel
1. Highlight the columns you want to transpose into rows. Press “Control C” to copy the data.
2. Open a new worksheet for the transposed data. Select an empty worksheet tab from the bottom of the Excel window, or press “Shift F11” to create a new worksheet. Rename the worksheet “Transposed Data.”
3. Right-click on cell “A1” to open the context menu. Select “Paste Special” from the menu to open the “Paste Special” dialog.
4. Check the “Transpose” box at the bottom of the “Paste Special” dialog to transpose the data. Click “OK.” Your data will be pasted into the spreadsheet as rows. Save your workbook.
Transposing Data in Access
5. Open the table you want to transpose. Select “Save As/Export” from the “File” menu. Select “To an External File or Database” in the 'Save As' window and click “OK.”
6. Give your table a name and select the version of Excel installed on your computer from the dialog box. Click “Export.”
7. Open your exported file in Microsoft Excel. Follow Steps 1-4 of “Transposing Data in Excel.” Close Microsoft Excel.
8. Import the transposed data into Microsoft Access. Select “Import” from the “File” menu. Use the “Files of Type” drop-down list and select “Microsoft Excel.”
9. Locate and select the file that contains the transposed data and click “Import.” Click “Show Worksheets” on the first screen of the Import Wizard and select the “Transposed Data” worksheet. Click “Next.”
10. Do not select the “First Row Contains Column Headings” option in the second screen of the Import Wizard; click “Next.” Check the “No Primary Key” option on the third screen of the Import Wizard and click “Finish” to import your data into a new table.

Blogger news