Copy random rows from columns from original table into a new table?
I've looked everywhere for an answer for this, I would be grateful if someone could help me.
I have a table made up of several columns, with each column containing multiple rows. Is there a set of rules/behaviours I can create to copy a random selection of rows from each of the columns into one giant column in a new table?
I want to create a game where I want the game to load a deck of cards with certain words (in table rows) on them, separated into topics (columns). The user selects what topics they want the words to come from. I then want the game to load a set of random words from the topics (aka columns) the user selected. The simplest way to do this in my head is to copy the rows from different columns from the first 'database table of words' into a temporary single column in a new table for use during one play session.
I hope this question makes sense? Any help would be greatly appreciated!