I have two lists that I want to compare. I can create a third list by doing
an if(countif(a:a,b1)0,b1,""), but what I would like to do instead is insert
blank cells (say in columns c thru j) where the lists don't match so that
they are aligned.
So If I have:

a1: D2233 b1:nodate c1:D2233 d1:notime
a2: D2234 b2:sdate c2:D2234 d2:stime
a3: D2235 b3:sdate c3:D2236 d3:stime
a4: D2236 b4:nodate c4:D2237 d4:stime

I would like to shift cells c3 and d3 down 1 so that they are aligned
correctly with a4 and b4 (indexing on columns a and c)