Copy Data from one sheet to another but allowing a space after the next value is found

[Kicassrt]

Hi Guys

I have been able to produce a column that gives me key date information. I might have many empty cells in that column before it hits another date. I need to get this data over to another sheet and place it in a row.

I am trying to get it to look like this:

B2(value), C2(value),D2(blank),E2(Value),F2(Value),G2(blank) etc depending on how many more elements are found in the sheet.


I am able to find topics that allow me to copy a range of data but not one that will allow me to copy a range then skip a cell.

Any thoughts?