Generate new rows for addresses with letters and numbers

[j_claude]

Hi all 

I have a question on generating new rows for a sequence of addresses with both numbers and letters. I have no trouble when it's only numbers - but I need the output to combine both numbers and letters. The letters are identifiers for different doors and can vary from address to address. 

The addresses are stored as an interval in one row - but I need a new row "10A", "10B" and "1C" then "2A", "2B" and "2C" and so on, so that each address has its own row. The "letter ranges" are not always A to B but could also be A to D. 

Current structure:  

City	Address	Number of residents	Info xx
Arkansas	New Street 10A - 12B	25
New York	Other Street 11A - 12D	20

Desired structure (only showed for Arkansas address) 

City	Address	Number of residents	Info xx
Arkansas	New Street 10A	25
Arkansas	New Street 10B	25
Arkansas	New Street 11A	25
Arkansas	New Street 11B	25
Arkansas	New Street 12A	25
Arkansas	New Street 12B	25

Hope someone can help! 

[FrederikE]

Hey @j_claude,

That was a cool challenge ;) 

[Christina_H · Accepted solution]

Here's a solution, using formulas from here: Solved: Generate Rows: increment letters like numbers - Alteryx Community

[j_claude]

Thank you so much both of you. This was very helpful! 

[BS_THE_ANALYST]

Late to the party! I was intrigued by your problem @j_claude :