Hi Airtablelers!

I’m struggling with a logic problem here and would really appreciate some insights.

I have a Spaces table that lists the shelf spaces I have in a store.

Each space is defined by its column number and a letter specifying its row. Each column is different so not every column has every letter.

Then I have a Brands table where I need to assigns these shelf spaces to different brands.

For the brands table I want to create a Linked Record or Dropdown that lists every space available. basically listing all the combinations from my Spaces table.

In this example the list would be like:

1A

1C

2A

2D

3C

Is this achievable at all? What’s the best way to achieve this?

Thank you so much!