How to display specific columns from one table to another?

If the "first entry" column in the Data Table is always column B, the formula for that one is very simple.

Cell B2 in Display Table =Data Table::B2

Fill down to complete the column

If the "last entry" is always the rightmost column because you add columns to "Data Table" to make a new entry, one formula would be

Cell C2 of the Display Table = OFFSET(Data Table::A$1,ROW()−1, COLUMNS(Data Table::$1:$1)−1)

Fill down to complete the column

These can be modified to remove any zeros (blank cells = 0) if that is necessary.

About your second question, it sounds like you want a "form" where you enter data into a form and "submit" it to another table then the form clears itself for the next set of data. That is not a feature of Numbers on the Mac.

Adding to the above,

If your Data Table has blank columns to the right, here are two alternative formulas for column C. Both require the headers to be filled in ("six entry", "seventh entry" etc.) because that is how they tell which are the filled in columns.

C2 =OFFSET(Data Table::A$1,ROW()−1,COUNTA(Data Table::$1:$1))

or

C2 =XLOOKUP(REGEX("\d|\w"),Data Table::$1:$1,Data Table::2:2,"",2,−1)

The first is more traditional but there can be no gaps in your columns (i.e., no blank columns in the middle). The second relies on some newer functions and allows blank columns in the middle.

Some more thoughts on your second question about a data entry form.

Something can be rigged up with formulas and filters to look like a data entry form. It is kind of slick but complicated. It is really a table that uses formulas and a filter to show one blank row at a time, hiding all all the formerly completed rows and all the other blank rows. In the end, it is really just your Data Table, transposed (entries are in rows not columns), with all the data hidden. And if you make a mistake, you have to turn off the filter so the row shows again, make your change, then turn the filter back on. But if you want a data entry form, this is how it can be done.

Here is how it looks. First screenshot is how it really looks, before hiding the first column and turning on the filter. Second is after doing those two things but before clicking "submit". After clicking "submit", you will see an empty row, ready for the next entry. The Data Table uses a formula that turns the data into text (so there are no zeros displayed for blank cells), which is why everything is left justified in the cells.