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
