Hi everyone,
I'm looking for a formula that will interpose 2 sets of row into 5 columns.
In A:E there is 5 cells : date, 3 digits and a $ amount and the same from G:K.
Those are lottery draws that happen twice per day, that's why each row has the same date, one is Mid day and the other is Evening.
What I'm looking for is to interlace those 2 draws per day into just 5 columns from M:Q like the example show.
Thank you.
I'm looking for a formula that will interpose 2 sets of row into 5 columns.
In A:E there is 5 cells : date, 3 digits and a $ amount and the same from G:K.
Those are lottery draws that happen twice per day, that's why each row has the same date, one is Mid day and the other is Evening.
What I'm looking for is to interlace those 2 draws per day into just 5 columns from M:Q like the example show.
Thank you.
