Spreadsheet: 762391d1641541775-excel-formula-to-combine-a-list-of-girls-and-boys-into-one-list-list-of-students
Sheet: Sheet1

Kindly asking for excel formula which can combine two different list of boys and girls into one list as shown on the desired outcome.
 |  |  |  |  |  |  |  | DESIRED OUTCOME
BOYS |  |  |  | GIRLS |  |  |  | Combined List
I.D | Name | Contact |  | I.D | Name | Contact |  | I.D | Name | Contact
CT 001 | ALAN MAYO | [PHONE] |  | ST 001 | ETHEL SIBANDA - Beam | [PHONE] |  | CT 001 | ALAN MAYO | [PHONE]
CT 002 | [NAME] | 30 223 4357 |  | ST 002 | BLESSING JOELS | 30 224 2343 |  | ST 006 | [NAME] | 34 224 2344
CT 003 | BIGBOY HARVEY | 30 223 4358 |  | ST 003 | ANGELLA CHANGE | 31 224 2345 |  | CT 004 | ANDREY NDAGURWA | 30 223 4310
CT 004 | ANDREY NDAGURWA | 30 223 4310 |  | ST 004 | CAROL SMITH | 32 224 2342 |  | ST 003 | ANGELLA CHANGE | 31 224 2345
CT 005 | RYAN ABRAHMS | 31 223 4340 |  | ST 005 | BERTHA PORTIA | 33 224 2347 |  | CT 006 | [NAME] | 32 223 4348
CT 006 | [NAME] | 32 223 4348 |  | ST 006 | [NAME] | 34 224 2344 |  | CT 009 | [NAME] | 33 223 4380
CT 007 | CARLTON MUZARABANI | 32 245 4356 |  | ST 007 | [NAME] | 35 224 2341 |  | ST 005 | BERTHA PORTIA | 33 224 2347
CT 008 | DENZEL TRUMP | 33 223 4357 |  | ST 008 | CHLOE M. NCUBE | 36 224 2348 |  | CT 003 | BIGBOY HARVEY | 30 223 4358
CT 009 | [NAME] | 33 223 4380 |  | ST 009 | [NAME] CHIVERE | 37 224 2349 |  | ST 002 | BLESSING JOELS | 30 224 2343
CT 010 | [NAME] | 34 223 4387 |  | ST 010 | LYDIA NDLOVU | 38 224 2346 |  | CT 013 | BRADLEY ISAAC | 35 223 4351
CT 011 | CADWELL MASINA | 34 223 4354 |  |  |  |  |  | CT 011 | CADWELL MASINA | 34 223 4354
CT 012 | [NAME] | 35 223 4399 |  |  |  |  |  | CT 007 | CARLTON MUZARABANI | 32 245 4356
CT 013 | BRADLEY ISAAC | 35 223 4351 |  |  |  |  |  | ST 004 | CAROL SMITH | 32 224 2342
CT 014 | [NAME] | 35 223 4354 |  |  |  |  |  | ST 008 | CHLOE M. NCUBE | 36 224 2348
 |  |  |  |  |  |  |  | CT 008 | DENZEL TRUMP | 33 223 4357
 |  |  |  |  |  |  |  | CT 014 | [NAME] | 35 223 4354
 |  |  |  |  |  |  |  | ST 001 | ETHEL SIBANDA - Beam | [PHONE]
 |  |  |  |  |  |  |  | CT 002 | [NAME] | 30 223 4357
 |  |  |  |  |  |  |  | ST 007 | [NAME] | 35 224 2341
 |  |  |  |  |  |  |  | CT 010 | [NAME] | 34 223 4387
 |  |  |  |  |  |  |  | ST 010 | LYDIA NDLOVU | 38 224 2346
 |  |  |  |  |  |  |  | ST 009 | [NAME] CHIVERE | 37 224 2349
 |  |  |  |  |  |  |  | CT 012 | [NAME] | 35 223 4399
 |  |  |  |  |  |  |  | CT 005 | RYAN ABRAHMS | 31 223 4340
 |  |  |  |  |  |  |  | CT 003 | BIGBOY HARVEY | 30 223 4358
 |  |  |  |  |  |  |  | ST 002 | BLESSING JOELS | 30 224 2343
 |  |  |  |  |  |  |  | CT 013 | BRADLEY ISAAC | 35 223 4351
 |  |  |  |  |  |  |  | CT 011 | CADWELL MASINA | 34 223 4354
 |  |  |  |  |  |  |  | CT 007 | CARLTON MUZARABANI | 32 245 4356
 |  |  |  |  |  |  |  | ST 004 | CAROL SMITH | 32 224 2342
 |  |  |  |  |  |  |  | ST 008 | CHLOE M. NCUBE | 36 224 2348
 |  |  |  |  |  |  |  | CT 008 | DENZEL TRUMP | 33 223 4357
 |  |  |  |  |  |  |  | CT 014 | [NAME] | 35 223 4354
 |  |  |  |  |  |  |  | ST 001 | ETHEL SIBANDA - Beam | [PHONE]
 |  |  |  |  |  |  |  | CT 002 | [NAME] | 30 223 4357
 |  |  |  |  |  |  |  | ST 007 | [NAME] | 35 224 2341
 |  |  |  |  |  |  |  | CT 010 | [NAME] | 34 223 4387
 |  |  |  |  |  |  |  | ST 010 | LYDIA NDLOVU | 38 224 2346
 |  |  |  |  |  |  |  | ST 009 | [NAME] CHIVERE | 37 224 2349
 |  |  |  |  |  |  |  | CT 012 | [NAME] | 35 223 4399
 |  |  |  |  |  |  |  | CT 005 | RYAN ABRAHMS | 31 223 4340