Combining cells for repeated content/values

[LeandroHBayer]

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?

Thanks!

Leandro

[Mike_AutomaticN · Accepted solution]

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!

Best,
Mike, Consultant @ Automatic Nation

[Alexey_Gusev]

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]

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

Bests,

L