Hi There, I have a problem my output is in the form attached, if the value of the output is zero or there is no data it goes and plots the next data in the next column, but what I need there is an actual zero or no data. Basically I need the numbers of my columns to all line up such that they match the numbers in the first row (1-90).
For example in row 4 Column F there is a 4 because of lack of data for the first 3 entries, instead I need this to be blank or zeros and the 4 to actually be in column L where it should belong. There are many skipped data points in each row and they are basically random. Hopefully that makes sense. Please let me know if I can do anything with macros to help fix this. Thanks
Anton
Bookmarks