Spreadsheet: 773595d1647951227-need-a-way-of-combining-headers-to-data-example-2
Sheet: Sheet1

What I have
 | Code | Name |  |  | Group | Credit Days
 | Date | Int. | Ref. | Ext. Ref. |  | Foreign | Total (EUR) | Unallocated | Current | 30 Days | 60 Days | 90 Days | 120 Days ++
 | 000087 | ABC LTD |  |  | IC | 0
 | 18/09/2020 | IN | 070825 | 002946 |  |  | 66439.67 |  |  |  |  |  | 66439.67
 | 18/09/2020 | IN | 070826 | 003425 |  |  | 28348.99 |  |  |  |  |  | 28348.99
 | 18/09/2020 | IN | 070827 | 003802 |  |  | 312225.57 |  |  |  |  |  | 312225.57
 | 18/09/2020 | IN | 070828 | 003803 |  |  | 482508.27 |  |  |  |  |  | 482508.27
 | 18/09/2020 | IN | 070829 | 003804 |  |  | 28615 |  |  |  |  |  | 28615
 | Client Totals |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
 | 000088 | 123 LTD |  |  | IC | 0
 | 18/09/2020 | IN | 070836 | 003805 |  |  | 169549.72 |  |  |  |  |  | 169549.72
 | 18/09/2020 | IN | 070837 | 003806 |  |  | 26550 |  |  |  |  |  | 26550
 | 18/09/2020 | IN | 070842 | 070190 |  |  | 89052.96 |  |  |  |  |  | 89052.96
 | 18/09/2020 | IN | 070843 | 070191 |  |  | 171404.37 |  |  |  |  |  | 171404.37
 | 18/09/2020 | IN | 070844 | 004542 |  |  | 26420.49 |  |  |  |  |  | 26420.49
 | Client Totals |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
 | 13206 | ZXY LTD |  |  | IC
 | 28/04/2021 | IN | 154076 | SRGN-TripAdviso |  |  | 64.89 |  |  |  |  |  | 64.89
 | 07/05/2021 | IN | 154125 | SRGN_Payroll Ap |  |  | 2862.46 |  |  |  |  |  | 2862.46
 | 07/05/2021 | IN | 154127 | SRGN Facebook A |  |  | 295 |  |  |  |  |  | 295
 | 28/05/2021 | IN | 154312 | SRGN - Selectio |  |  | 175.82 |  |  |  |  |  | 175.82
What I need
 |  |  |  |  |  |  | 0
IN | 000087 | ABC LTD | 18/09/2020 | IN | 070825 | 002946 | IC |  | 66439.67 |  |  |  |  |  | 66439.67
IN | 000087 | ABC LTD | 18/09/2020 | IN | 070826 | 003425 | IC |  | 28348.99 |  |  |  |  |  | 28348.99
IN | 000087 | ABC LTD | 18/09/2020 | IN | 070827 | 003802 | IC |  | 312225.57 |  |  |  |  |  | 312225.57
IN | 000087 | ABC LTD | 18/09/2020 | IN | 070828 | 003803 | IC |  | 482508.27 |  |  |  |  |  | 482508.27
IN | 000087 | ABC LTD | 18/09/2020 | IN | 070829 | 003804 | IC |  | 28615 |  |  |  |  |  | 28615
 |  |  | Client Totals |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0
IN | 000088 | 123 LTD | 18/09/2020 | IN | 070836 | 003805 | IC |  | 169549.72 |  |  |  |  |  | 169549.72
IN | 000088 | 123 LTD | 18/09/2020 | IN | 070837 | 003806 | IC |  | 26550 |  |  |  |  |  | 26550
IN | 000088 | 123 LTD | 18/09/2020 | IN | 070842 | 070190 | IC |  | 89052.96 |  |  |  |  |  | 89052.96
IN | 000088 | 123 LTD | 18/09/2020 | IN | 070843 | 070191 | IC |  | 171404.37 |  |  |  |  |  | 171404.37
IN | 000088 | 123 LTD | 18/09/2020 | IN | 070844 | 004542 | IC |  | 26420.49 |  |  |  |  |  | 26420.49
 |  |  | Client Totals |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
IN | 13206 | ZXY LTD | 28/04/2021 | IN | 154076 | SRGN-TripAdviso | IC |  | 64.89 |  |  |  |  |  | 64.89
IN | 13206 | ZXY LTD | 07/05/2021 | IN | 154125 | SRGN_Payroll Ap | IC |  | 2862.46 |  |  |  |  |  | 2862.46
IN | 13206 | ZXY LTD | 07/05/2021 | IN | 154127 | SRGN Facebook A | IC |  | 295 |  |  |  |  |  | 295
IN | 13206 | ZXY LTD | 28/05/2021 | IN | 154312 | SRGN - Selectio | IC |  | 175.82 |  |  |  |  |  | 175.82