This is quite smart, but as you say, also convoluted. I'm not a QB expert and have been confused by a couple of aspects:

- why isn't there a designated ship-to country field that I can draw into the report?

- why is the report (for me) grouping on customer number and address?  I can work with it but it makes the excel work harder.  Can I switch off such grouping?

(I need to extract formatted ship-to addresses into another application and it's been bugging me for months).