Suggest me how to concatenate one record with the remaining records.
For example, If I have thousand records then one record should concatenate with the remaining records.
This is the dummy data, Please help me in solving this
INPUT:
| col A | Col B |
| 00 | A |
| 01 | B |
| 02 | C |
| 03 | D |
| 04 | E |
Expected Output:
| Col A1 | ColA2 | ColB1 | ColB2 | Relationship |
| 00 | 01 | A | B | 00_01 |
| 01 | 00 | B | A | 01_00 |
| 00 | 02 | A | C | 00_02 |
| 02 | 00 | C | A | 02_00 |
| 00 | 03 | A | D | 00_03 |
| 03 | 00 | D | A | 03_00 |
| 00 | 04 | A | E | 00_04 |
| 04 | 00 | E | A | 04_00 |
| 01 | 02 | B | C | 01_02 |
| 02 | 01 | C | B | 02_01 |
| 01 | 03 | B | D | 01_03 |
| 03 | 01 | C | B | 03_01 |
| 01 | 04 | B | E | 01_04 |
| 04 | 01 | E | B | 04_01 |
| 02 | 03 | C | D | 02_03 |
| 03 | 02 | D | C | 03_02 |
| 02 | 04 | C | E | 02_04 |
| 04 | 02 | E | C | 04_02 |
| 03 | 04 | D | E | 03_04 |
| 04 | 03 | E | D | 04_03 |
