Hi alekos7 and welcome to the forum.
Is this the outcome you envisioned?
Row\Col |
A |
B |
C |
D |
1 |
ID1 |
ID2 |
ID1 |
ID2 |
2 |
SLS.123 |
GPS.111 |
SLS.123 |
GPS.111 |
3 |
SLS.123 |
GPS.222 |
SLS.123 |
GPS.222 |
4 |
SLS.123 |
GPS.222 |
SLS.234 |
GPS.222 |
5 |
SLS.234 |
GPS.222 |
SLS.123 |
GPS.333 |
6 |
SLS.123 |
GPS.333 |
SLS.299 |
GPS.444 |
7 |
SLS.123 |
GPS.333 |
SLS.123 |
GPS.444 |
8 |
SLS.299 |
GPS.444 |
SLS.333 |
GPS.555 |
9 |
SLS.123 |
GPS.444 |
|
|
10 |
SLS.299 |
GPS.444 |
|
|
11 |
SLS.333 |
GPS.555 |
|
|
After trimming and cleaning the data in columns A:B I array entered this formula in C2 filled down and across. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.
Bookmarks