JSFiddle - React, Tailwind, and code Playground
HTML
<table>
<tbody>
<tr>
<td class="list-cell__cabin">
<select name="cabin1" id="cabin1">
<option value="1" selected>Cabin #1</option>
<option value="2">Cabin #2</option>
<option value="3">Cabin #3</option>
<option value="4">Cabin #4</option>
</select>
</td>
<td class="list-cell__months">
<select name="months1" id="months1" multiple>
<option value="1" selected>Jan</option>
<option value="2" selected>Feb</option>
<option value="3">Mar</option>
<option value="4" selected>Apr</option>
</select>
</td>
<td class="list-cell__year">
<select name="year1" id="year1">
<option value="2021" selected>2021</option>
<option value="2022">2022</option>
<option value="2023">2023</option>
<option value="2024">2024</option>
</select>
</td>
</tr>
<tr>
<td class="list-cell__cabin">
<select name="cabin2" id="cabin2">
<option value="1" selected>Cabin #1</option>
<option value="2">Cabin #2</option>
<option value="3">Cabin #3</option>
<option value="4">Cabin #4</option>
</select>
</td>
<td class="list-cell__months">
<select name="months2" id="months2" multiple>
<option value="1">Jan</option>
<option value="2">Feb</option>
<option value="3">Mar</option>
<option value="4"selected>Apr</option>
</select>
</td>
<td class="list-cell__year">
<select name="year2" id="year2">
<option value="2021" selected>2021</option>
<option value="2022">2022</option>
<option value="2023">2023</option>
<option value="2024">2024</option>
</select>
</td>
</tr>
<tr>
<td class="list-cell__cabin">
<select name="cabin3" id="cabin3">
<option value="1">Cabin #1</option>
...
JavaScript
var obj = [];
$('table').find('.list-cell__months select').each(function(a) {
var months = $(this).val();
var cabin = $(this).closest('tr').find('.list-cell__cabin select').val();
var year = $(this).closest('tr').find('.list-cell__year select').val();
obj.push({
'year': year,
'cabin': cabin,
'months': months
});
});
console.log(obj);
const addUnique=(arr1,arr2)=>{
arr2.forEach(item=>arr1.includes(item) || arr1.push(item))
return arr1;
}
const grouped= obj.reduce((groups,item)=>{
const yearItems=(groups[item.year]||[])
const cabinItem=yearItems.find(({cabin})=>cabin===item.cabin)
const newCabinItem=cabinItem||{cabin:item.cabin};
newCabinItem.months=addUnique(newCabinItem.months||[],item.months);
return {
...groups,
[item.year]: cabinItem?yearItems.map(yearItem=>yearItem.cabin===item.cabin?newCabinItem:yearItem):yearItems.concat([newCabinItem])
}
},{})
console.log(grouped)