This seems so simple, but I am unable to finding a solution for it.
I am trying to show all values from one table, in another table, on separate rows, but without creating a view of that table. (The reason why it can’t be a view, is that the new table will be a “detailed” table, that we will use to search for a specific value, this can only be the display col value, but display value needs to remain fixed in the original table).
Atm, I wrote a formula, which is just “originalTable”, this then pulls in all the values from the original table in the new table, but it puts them all in the first row.
How can I display all the values in the new table but on seperate rows?