For all of my observations I needed to create an extra row for each month since Jan05 with the obs against it; so each observation would appear 79 times (number of months since Jan05). I have additional data at obs level but only appearing in certain months; but my customer wants to see all months even if the observation does not have a record against it. With my original data now I can do a simple merge by obs & date to keep all obs for all months. I had actually created what I required before posting, but it seemed such a convoluted solution, that I thought there must be an easier way; and there was! Both options worked fine, but I went with the yonib's in the end. Thanks to everyone who replied. ... View more

Thanks for all the help, it all works perfectly now. 🙂 ... View more

Sorry, I've ised the lrecl= to set width and it appears ok. However, I want to confirm that by setting the lrecl= does that affect the 'carriage return' ({CR}{LF} character pair) I need at the end of each line? Thanks...... ... View more

Thanks data _null_. I got it working apart from one issue. The actual width of my report is much larger than the example and has 45 variables. Before it reached the end of the first observation though the text file creates at carriage return (without a comma separation) and creates a new line. EG: - "56979","GCR011","3882","Actual" "2010-10-31","179.09" "45153","GCR011","3000","Actual","2011-01-31" "75.80" Is there a way around this at all? Thanks... ... View more

Thanks for the 'good' news. I'll investigate more on the MS Add-in. ... View more

Thanks for the response. Unfortunately, we don't have the PC File formats licensed. Are you able to point me in any direction for training material etc. The Excel format cannot change at all, due to it's external regulatory audience, so does that mean that MS Excel add-in is my only option? Will that mean I still need to use VBA to populate the exact cells with the correct data? ... View more

Thanks Scott It worked a treat. ... View more