Hi All,
I am having abit of a mare and struggling to think of how to solve this use case.
I have the following excel and the data structure is as follows, ( every 2 rows are a group)
| Source | Identifier | Name | Address |
| UNKNOWN | xxxxxxxx | Mason LTD | 123 High Street |
| DB | 111111111 | Mason LTD | 1234 High Street |
My steps so far is as follows ;
- Add a "Record ID" Create a new column called RecordID
- Add a formula with the following CEIL([RecordID]/2)
This gives me the following
| Record | Source | Identifier | Name | Address | Group |
| 1 | UNKNOWN | xxxxxxxx | Mason LTD | 123 High Street | 1 |
| 2 | DB | 111111111 | Mason LTD | 1234 High Street | 1 |
From here what i would like to do is get to this outcome
| Group | Identifier | Identifier | Name | Name | Address | Address |
| 1 | xxxxxxxx | 111111111 | Mason LTD | Mason LTD | 123 High Street | 1234 High Street |
Really appreciate any assistance
Kind Regards
Masond3
