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

Please provide the abbreviation codes required for all airlines in your database.

CM = CENTRAL MOUNTAIN
AC = AIR CANADA
WJ = WESTJET
etc...

This will do it, just add to the section of the code with the first 5 letters of the airline name and the abbreviation pairs starting at line 25....

Please Login or Register  to view this content.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

Alternative:

Please Login or Register  to view this content.