Discussion Locked

Rotate data in Access2000

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a CSV file which has 10 rows and 3 columns.
How do I import this data into an Access2000 table so that the rows become the columns and the columns become the rows?

4 replies

by misscrf

Import the data into a table and make a pivot table. You can do this in excel or access. You will have to play with it to get the row data into the column data as you want it.
good luck.

by dliby

Using a pivot table does not solve my problem. I did figure it out in Excel by selecting the cells I wanted to switch. Then click on copy. Select the upper-left cell of the paste area. On the Edit menu, click Paste Special. Select Transpose check box. Hit okay and it works.

This discussion is closed to new replies.