Format each Row of Table into separate lines (Formula)

Hello,

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
etc…

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.

You can add another column to [Rosemary Cook], and enter the following formula for that column:

Concatenate("''",Title,"''"," ",[Dog Breed],", ",Medium," ",Dimension)

The blank quotes (" ") are for the spaces, and the " ’ ’ " is to add quotes inside the Concatenate.

3 Likes

Hi @Philippe_Roy,
Would it work for you to create a new column (called Summary) and then use a column formula there
= “”" + Title + “”" + Dogbreed + ", " + Medium + ", " + Dimensions.

Then you could either copy the column or use a canvas formula = [Rosemary Cook]. Summary or [Rosemary Cook]. Summary.BulletedList()

2 Likes

Great, thank you to you both, both ways work exactly the way I wanted.

=Concatenate("“",Title,"” ",[Dog Breed],", ",Medium,", ",Dimension)

="“" + Title + "” " + [Dog Breed] + ", " + Medium + ", " + Dimension

And then the Summary bulleted list lists it out the way I needed, very powerful :smiley:

So + and Concatenate do the same thing in essence.

1 Like