Back again.

In fact, you have done nothing wrong. Strange things can happen when copy/pasting times. It's due either to time being expressed to a different number of dps or to the fact that excel can't count. (See link). It can be fixed int he formual using some clunky rounding. However, since (in this case) all 3 time axes were identical, I just selected the time axis in your raw data copy/paste special ± transpose into your output. As if by magic, all the blanks disappearred.

Hopefully, that's everything sorted.

If so, you're welcome. If not, shout.


If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.