Transposing Data from Row to 2 Column format

Hello all,

Heres my problem:

I have to break down these flight routes from row format to 2 column format.

Example:

Data:
1 2 3
YQQ YVR YQQ

Result wanted:
1 YQQ YVR
2 YVR YQQ

The difficulty here is that the data sample does not have the extra "YVR" embedded in the row.

I have attached a test worksheet with my preferred results.
Thanks for the help guys!

Test worksheet.xlsx