How to get Canadian Postal Codes within a set range

[nonameprofessional12]

I am looking for a code or formula to populate all Canadian Postal codes within a set of ranges.

For example I have a beginning postal code of A0A 6J6 in column A and an ending postal code of A0A 6X1 in column B that belongs to City/Province in column C. I want to populate all of the possible Canadian Postal Codes within that range.

I have attached an example of the data I have, and included an example of how I want it to populate.

Any help is greatly appreciated!


Desired Outcome:

Beginning Postal Code Ending Postal Code City / Province
A0A 6J6 A0A 6X1 CONCEPTION BAY SOUTH, NL


A0A 6J6 CONCEPTION BAY SOUTH, NL
A0A 6J7 CONCEPTION BAY SOUTH, NL
A0A 6J8 CONCEPTION BAY SOUTH, NL
A0A 6J9 CONCEPTION BAY SOUTH, NL
A0A 6K0 CONCEPTION BAY SOUTH, NL
A0A 6K1 CONCEPTION BAY SOUTH, NL
A0A 6K2 CONCEPTION BAY SOUTH, NL
A0A 6K3 CONCEPTION BAY SOUTH, NL
A0A 6K4 CONCEPTION BAY SOUTH, NL
A0A 6K5 CONCEPTION BAY SOUTH, NL
A0A 6K6 CONCEPTION BAY SOUTH, NL
A0A 6K7 CONCEPTION BAY SOUTH, NL
A0A 6K8 CONCEPTION BAY SOUTH, NL
A0A 6K9 CONCEPTION BAY SOUTH, NL
A0A 6L0 CONCEPTION BAY SOUTH, NL
A0A 6L1 CONCEPTION BAY SOUTH, NL