You can first FILTER your range so that you're just left with the rows that you want. This would look like this =FILTER(C2:D6, C2:C6 = 1). Then you'd need to somehow join the values in cells you've filtered. You could use TEXTJOIN for this =TEXTJOIN(",", TRUE, TO_TEXT(F6), TO_TEXT(F7)). I have cells from column F in my TEXTJOIN because that is ...
One easy way to manage recurring images such as logos is to create a column, say column I, that holds them all. You can fetch the images into column I with image() formulas like this:
Then refer to the image column whenever you want to display an image,...
Your data table looks nice and pretty — i.e., it is like a report.
The best practice is to keep your data row-oriented and simple, and create reports separately — do not try to make your data look like a report.
You may want to use a row-oriented data layout, like this: