I have attached the contacts file and data file. How do I group same customer names together and have an output similar to below 2 sample desired outputs? Thank you for the help!
Output 1
| Unit | Receipt Number | Client name | Client full name | Deal date | Transaction type | Query Date |
| Delta | 16456 | Dee | Dee Claire | | Land | |
| Delta | 13544 | Dee | Dee Claire | | Land | 19-May-2023 |
| Delta | 12687 | Dee | Dee Claire | | Land | 19-May-2023 |
Output 2
| Unit | Receipt Number | Client name | Client full name | Deal date | Transaction type | Query Date |
| Alpha | 10200 | John | John Martin | 09-May-2023 | Clothes | 25-Apr-2023 |
| Alpha | 19293 | John | John Martin | 12-May-2023 | Clothes | 25-Apr-2023 |
| Alpha | 13096 | John | John Martin | 12-May-2023 | Clothes | |
| Alpha | 15136 | John | John Martin | 15-May-2023 | Clothes | 12-May-2023 |
| Alpha | 14647 | John | John Martin | 15-May-2023 | Clothes | |
| Alpha | 12432 | John | John Martin | 17-May-2023 | Shoes | |
| Alpha | 12517 | John | John Martin | 17-May-2023 | Shoes | |
| Alpha | 14874 | John | John Martin | 23-May-2023 | Air | 18-May-2023 |
