Hi Chris

I wonder if there is a way to amend the output.

I have some new data which is slightly different as follows:

CREATE TABLE VW_AE_SUS (

...

Hi Chris

Apologies, I've been away from my desk and had just finished populating the 'Insert' statement when your solution popped into my Inbox.

All I can say is I'm eternally grateful...

Hi Chris

I've attached some data and I will read through the suggested articles.

Thanks for such a rapid response.