Help

Re: Combining cells for repeated content/values

Solved
Jump to Solution
46 0
cancel
Showing results for 
Search instead for 
Did you mean: 
LeandroHBayer
4 - Data Explorer
4 - Data Explorer

Hello community,

I'm building some kind of table where it has repeated content in the rows that I would love to have them combined, similar to a merge cell in Excel or Google Spreadsheets.

Is it there a formula or a scripting that can help me have some structure like in the attached image?combined.png

Thanks!

Leandro

1 Solution

Accepted Solutions
Mike_AutomaticN
7 - App Architect
7 - App Architect

Hey @LeandroHBayer!

This might not be EXACTLY what you are looking for (as it will not do the math for you if you have numbers on your records). But you might want to check Airtable's extension called Dedupe. -see image below.

It will allow you to find duplicates, or similar records, and merge them as needed!

Mike_AutomaticN_0-1730220724184.png

Best,
Mike, Consultant @ Automatic Nation

See Solution in Thread

3 Replies 3
Mike_AutomaticN
7 - App Architect
7 - App Architect

Hey @LeandroHBayer!

This might not be EXACTLY what you are looking for (as it will not do the math for you if you have numbers on your records). But you might want to check Airtable's extension called Dedupe. -see image below.

It will allow you to find duplicates, or similar records, and merge them as needed!

Mike_AutomaticN_0-1730220724184.png

Best,
Mike, Consultant @ Automatic Nation

Hi,
Airtable is database. Each table represents a list of some objects of a similar type. 
Instead of spreadsheet like Excel, you should consider table as a list, (or group/array) of rows. Each row is object having properties, which are described as Field name/settings. Cell value is a value of a respective property.
Therefore, your final result 'How I needed it' should be a single record with Multi-Select field instead of Single-select. Field will contain 'Low','Medium','High'.

The second question is 'How to transform my current table into the table that looks like on example'
Deduper extension is good when you have 10-20 'duplicates' , but not hundreds.
Long time ago I tried to write a script merging records, but it can be done easier, manually, without any automation/scripts.
You should take a field which you want to be unique. Duplicate this field. Then convert duplicate to a Link Field (to +Create new table)
Then switch to a new table. With rollup ARRAYUNIQUE(values), one by one, recreate all fields you need and convert them to desired type.

LeandroHBayer
4 - Data Explorer
4 - Data Explorer

Thank you both for your inputs. It really helped me.

Bests,

L