First, I don’t know all the various terminology to explain what I would like to do exactly, but I can give by example.
Here is my table (edit: table name is Rosemary Cook):
I would like to concatenate each value for each row into the following format:
“Rusty” Airedale Terrier, Bronze resin, 10 x 8 x 5 inches
“Bob” Airedale Terrier, Bronze resin, 11 x 12 x 4 inches
I basically want to have a simplified view of the data that I can copy and paste as one line, and use elsewhere. I also would like for this to be done with one line of a formula considering there are many rows of data to be formatted.
Thank you for any help offered. I hope it can be done. I love the software, I have been desiring something like this for awhile after being let down by the capabilities of Excel and GSheets.