Hi all,
Pretty sure I should be able to do this already with previous help I have had here but for some reason I am just not getting it...
Every week I get a spreadsheet with data in the format attached (I've put in four blocks but it could be any number usually thousands). I need to copy the yellow cells in column A and put them in the blank cells next to the blue row in that block, then delete all the rows that aren't blue.
If anyone could assist, it would be awesome.
Cheers
Matt
Bookmarks