Thanks Scott!!!

I only had to change a few small bits but that was easy as your code was simple to follow once I got my head around how...

Thanks Scott.

Your solution works and the output data from the row with ID = 2 onwards is great. Has all of the weeks out to the end of the...

Hi Jeff,

That was just my bad putting it as a column in the original sample data. I was trying to create a simplified version of the input table but...

Thanks for the reply. Happy New Year btw.

I have been looking at the solution you provided for a few days over the break. The output you get...

Thanks.

One of the things I found when googling was the Pivot and Unpivot functions. I'm not sure if I was reading poorly written sites or it was just a...