Hello,
I have a large number of data points 2500, that includes blanks, that are in a grid , i wish to take these data points and place them into a single column. However I wish to skip the blank data points since they can skew our data. Does anyone have an idea on a macro or formula to shift through this data? Any help would be great. Thank you.