Spreadsheet: 684164d1593180224-formula-to-consolidate-a-range-in-a-single-column-sample
Sheet: Sheet1

202006
Société | Matr. | 01 | 01 | 02 | 02 | 03 | 03 | 04 | 04 | 05 | 05
1733 | 1947 | ACTPARS | 01.00 | 01.00 | ACTPARS | 01.00 | ACTPARS | 01.00 | ACTPARS | 01.00 | ACTPARS
1733 | 14361 |  |  |  |  |  |  | CP | CP | CP | CP
1733 | 14743 | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS
1733 | 17366 | MAL | MAL | MAL | MAL | MAL | MAL | MAL | MAL | MAL | MAL | in the same cell should be the following consolidation
1733 | 18369 | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS |  |  | first from societe
1733 | 25177 |  |  |  |  |  |  |  |  |  |  | 3 zeros
1733 | 26197 | ACTPARS | ACTPARS | ACTPARS | ACTPARS |  |  |  |  |  |  | first from matr
1733 | 29063 | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | A1 locked
1733 | 29252 | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | C2 locked on row
1733 | 31287 | SO | SO | ACTPARS | ACTPARS |  |  | ACTPARS | ACTPARS |  |  | If C2 is number, then c2 with a space. If c2 letters, then trim c2&a number of spaces equal with 8- the number of letters in the cell
1733 | 32585 | SO | SO | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | 3 zeros again
1733 | 33103 |  |  |  |  |  |  |  |  |  |  | and the vlookup
1733 | 33722
1733 | 33869 | ACTPARS | ACTPARS | ACTPARS | ACTPARS |  |  |  |  | CP | CP | 2 examples above
1733 | 34084 | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS
1733 | 34393 | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | Basically it needs to finish row 1 for first societe and matr(it may have 62 columns), them move to row 2, row 3 and so forth
1733 | 35862 | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | It should appear under a single column
1733 | 37826 | SO | SO | 01.00 | ACTPARS | 01.00 | ACTPARS | 01.00 | ACTPARS | 01.00 | ACTPARS
1733 | 39579 | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS
1733 | 40421 | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS
1733 | 45213 | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS
1733 | 45258 | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS
1733 | 48802 | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS
1733 | 49790 | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS
1733 | 51635 | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS
1733 | 54682 | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS
1733 | 55071 | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS
1733 | 56291 | ACTPARS | 02.00 | 02.00 | ACTPARS | 02.00 | ACTPARS | 02.00 | ACTPARS | 02.00 | ACTPARS
1733 | 56770 | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS
1733 | 57232 | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS
1733 | 57676 | SO | SO | ACTPARS | ACTPARS | ACTPARS | ACTPARS
1733 | 57699 | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS
1733 | 57756 | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS
1733 | 58368 | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS
1733 | 58724 | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS
1733 | 58976 | MAL | MAL | MAL | MAL | MAL | MAL | MAL | MAL | MAL | MAL
1733 | 60043 | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS
1733 | 60198 | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS
1733 | 60304 | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS
1733 | 60497 | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS
1733 | 60663 | ACTPARS | 01.00 | 01.00 | ACTPARS | 01.00 | ACTPARS | 01.00 | ACTPARS | 01.00 | ACTPARS
1733 | 62159 | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS
1733 | 62349 | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS | ACTPARS