Hi Experts.
Hoping you'll be able to help please.
I have a requirement to 'fill down' the contents of the columns to the next filled cell.
I would ordinarily do this by hand, but I have thousand of rows and multiple columns in my original worksheet.
Below is an image showing an example of the original file with a second Fill Down sheet showing what I'd ideally like please so that the receiving system can recognise the full records rather than 'empty cells'
The best of luck guys and thanks very much!
Mark
Hoping you'll be able to help please.
I have a requirement to 'fill down' the contents of the columns to the next filled cell.
I would ordinarily do this by hand, but I have thousand of rows and multiple columns in my original worksheet.
Below is an image showing an example of the original file with a second Fill Down sheet showing what I'd ideally like please so that the receiving system can recognise the full records rather than 'empty cells'
The best of luck guys and thanks very much!
Mark