Rotate tables (1 Viewer)

Is it possible to switch a table so that the columns become the rows and the rows become the columns and having the data change with it?

Thanks

Kind of using Excel. First select all the data in your table and copy it. Then open up Excel and paste the data to the spreadsheet. Next, select the data and choose copy. Open up a new worksheet and select paste special and choose transpose.

I think I saw something posted somewhere about a Transpose function. Do a search on this forum for Transpose.

Thanks for the advice, I'll look into it.

Beware that if you have ANY relationships at all using the source table, if you actually change that table, you kill the relationships.

This thing you want to do is a flat-file concept in a relational world. For a really short table, it makes sense. If the table has more than 255 records, though, you are screwed supremely because the resulting "flipped" table will require more fields than Access allows.

There is also the issue that the keys in this table suddenly make no sense either, even if no external relationships exist.

STRONGLY recommend rethinking the requirement to look for normalization and other "gotcha" items. If this is a one-time change, OK. If this is a commonly repeated event, your concept is going to eat your socks very quickly. Access might not be the tool for you. In that case, look hard at doing this entirely via Excel.