In *Column A* I have the id of the home team, *B* the name of the home team, *C* the id of the visiting team and in *D* the name of the visiting team:

```
12345       Borac Banja Luka    98765       B36
678910      Panevezys           43214       Milsami
1112131415  Flora               7852564     SJK
1617181920  Magpies             874236551   Dila

```

I want to create a column of ids and another of names but keeping the sequence of who will play with whom:

```
12345       Borac Banja Luka
98765       B36
678910      Panevezys
43214       Milsami
1112131415  Flora
7852564     SJK
1617181920  Magpies
874236551   Dila

```

Currently (the model works) I'm joining the columns with a special character, using flatten and finally split:

```
=ARRAYFORMULA(SPLIT(FLATTEN({
                             FILTER(A1:A&"§§§§§"&B1:B,(A1:A<>"")*(B1:B<>"")),
                             FILTER(C1:C&"§§§§§"&D1:D,(C1:C<>"")*(D1:D<>""))
                    }),"§§§§§"))

```

Is there a less archaic and correct approach to working in this type of case?

[Spreadsheet to tests](https://docs.google.com/spreadsheets/d/1twlYH1f8nYeVDXKHt0XsAk1kjiErm0RNfptyypw4DRc/edit?usp=sharing)