Side-by-Side Inline

I recently stumbled across a way to display a side by side inline list and thought I would share.

In my opinion the most aesthetically pleasing layout for this is a Tiles view with Tile Shape 3:2 and x2 per row.

Below we are pulling data from different columns for the right and left sides.

I did most of the work in GSheets and it uses a lot of rows so I’d be interested in moving the logic to Glide. Anyways here it goes…

Step 1
Create a list of duplicate Names (hello row count :crazy_face:)

Summary

=QUERY({A2:A;A2:A},"select *",1)

Step 2
Remove the blanks (Start a new tab and put this =filter in Column A)

Summary

=filter(Sheet1!A:A,not(isblank(Sheet1!A:A)))

Step 3
Now that we have a list of duplicate Names we can apply the following logic. (The first time our formula finds a name mark it “Sales” the second time mark it “Commissions”)

Summary

=ARRAYFORMULA(if(isblank(A2:A),"",if(if(A2:A=A2:A,COUNTIFS(A2:A,A2:A,ROW(A2:A),"<="&ROW(A2:A)),)=1,"Sales","Commissions")))

Step 4
Next we use “Sales” & “Commissions” as conditions for a =vlookup to make the magic column.

Summary

=arrayformula(if(B2:B="Sales",VLOOKUP(A2:A,NAMEDRANGE,2,FALSE),if(B2:B="Commissions",VLOOKUP(A2:A,NAMEDRANGE,3,FALSE),"")))

Step 5
Finally set filter in glide to Name is > Screen > Name and… Voila!

8 Likes