Way in Numbers to flip columns with rows

I found the following tutorial at Apple that has the answer to my own question: The default table styles are always taken from the table style list that you choose from the panel on the bottom-left corner of the screen.

The solution to my problem is to use the Create New Table Style command under the Format menu and adding a brand new table style. As long as this new style remains selected, it is the one that the table will keep as a whole.

I have tried this at home and it works as advertised.

Numbers as a spreadsheet operates very well for its intended design, calculating, storing and displaying (in a pretty way) tabulated data. However many people try to use spreadsheets as databases. When emulating a relational database, of sorts, using a spreadsheet is clunky at best.

Making links to individual cells in different tables on different sheets is easy, but filtering entire rows remotely on a separate table is quite another task.

Databases use a unique ID in so as to reference data between tables. You can use this to do so with formulas in Excel and Numbers but to automate this process may require scripting. (In the case of Excel, VBA. Numbers can be scripted with Applescript.) iWork Automation has several tutorials and examples on how to script Numbers.

What I have used to good success in referencing data from a master sheet or table is the following formula:

Index ( Match ())

There is a plethora of information on the Internet as to how to use this formula, and there are many ways to implement it. Getting the N^th row based on criteria without a filter is tricky, however.

This answer for Excel VBA on Stackoverflow may be a start that can be used as a base (with proper syntax formatting of course) for an AppleScript service that may work.