I HAVE A VALUE IN A COLUMN WHICH IS MUCH LIKE A HEADING FOR THE FOLLOWING ROWS. I WOULD LIKE TO KNOW IF THERE IS A WAY TO REPEAT THE VALUE ONTO EACH OF THE ROWS IN THAT COLUMN - STOP WHEN IT COMES TO A NEW VALUE AND REPEAT THE NEW VALUE FOR THE FOLLOWING ROWS, STOP WHEN IT COMES TO ANOTHER...