I have a column of values on Sheet 1 (A:A). There are blanks in this data and these are dependant on the value in column B.
The blanks vary from week to week.
On Sheet 2 I would like the data carried over from Sheet 1 (A:A) but grouped up without spaces, I can’t just paste and remove blanks as the data is going to be varying all the time.
Thanks for any help
The blanks vary from week to week.
On Sheet 2 I would like the data carried over from Sheet 1 (A:A) but grouped up without spaces, I can’t just paste and remove blanks as the data is going to be varying all the time.
Thanks for any help