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
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…
Create a list of duplicate Names (hello row count )
Remove the blanks (Start a new tab and put this
=filter in Column A)
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”)
Next we use “Sales” & “Commissions” as conditions for a
=vlookup to make the magic column.
Finally set filter in glide to Name is > Screen > Name and… Voila!