Address Book Sort into different Columns

Sorry, it's taken me a little while to finish tinkering with your sample workbook.

I have attached an updated version for your review.

You should find that you can copy the formulae in row 2 down through the worksheet and you will get only one row of transcribed data for each block.

Copy and Paste Special values to remove the formulae with "blank" content.

Regards