Hello,
Grantmaking foundation migrating from FileMaker to Airtable. I have 10 columns in a table that I want to merge into one column. Each of these columns consists of a different grant budget. I want to merge these columns into one column, while differentiating the data. I need to know which budget the grant belongs to, but it doesn’t make sense to have 10 columns when I can use a single select feature and select a the appropriate budget. But I am stuck on how to accomplish this. Any guidance is much appreciated!
Chad