Formula help for combining info from each row

[Joanna_Lamb]

I have a table showing test scores and I want to do a summary of the scores on the bottom. I want it to take each row one at a time and show the results from all the columns in that row:

[TYPE FIRST ROW] score of [SCORE FIRST ROW] which is [DESCRIPTIVE RANGE FIRST ROW]

[TYPE SECOND ROW] score of [SCORE SECOND ROW] which is [DESCRIPTIVE RANGE SECOND ROW]

Right now, I can only get it to do this

[TYPE FIRST ROW, SECOND ROW] score of [SCORE FIRST ROW, SECOND ROW] which is [DESCRIPTIVE RANGE FIRST ROW, SECOND ROW]

What formula should I use?

[Quentin_Morel]

Hi @Joanna_Lamb

I’m not sure i did well understand your wish, but I try this :

If you want to digest data frome table 1 in kinda summary, you can use a combination of ForEach() function and Format() function

In this example, ForEach() will go through each row, and apply the Format function to create a sentence displaying your different column

Of course this work for any row from Table 1

Please let me know if this is OK for you

Cheers

PS : If you dont want the bullet point, but only linebreak, try something like this