Get an table of unique booking numbers…
For Each Row in Datatable through that table
- Filter mainDT based on current value
- Concatenate into one string
- Send as email
//end for each
There’s no reason to try to group them in Excel the way you originally asked.