Here is an interesting problem to keep you busy.
Transpose the address data in column A into the format indicated in C:G using either VBA, formulas or Power Query. Once done, post your answers in comments section.
Read these rules before solving:
- First download the problem workbook.
- Each address may have up to 8 lines.
- Each address is delimited by a blank line.
- Once you finish your formula / VBA / Power Query code, when pasting that in comment box,
- First write <PRE>
- then paste your code
- Then write </PRE>
Go ahead and solve.