HI,
I'm not really sure how to describe this problem, it's a simple concept I think but my excel/vba knowledge is limited and im struggling to find a solutions.
So the data i have looks like this, where the first three columns A,B,C are simply dates going down to lets say row 20, Columns D:BK are similar to what is below (mixture of letters/numbers) and I want to perform some function or macro that takes me from Figure 1, to Figure 2.
Figure1:
1/2/2015 1/3/2015 1/5/2015
1/15/2015 1/16/2015 1/5/2015 abc123 abc345
1/22/2015 1/23/2015 1/20/2015 aab123
1/29/2015 1/30/2015 1/13/2015 cba123 cbb123 cbc432
1/22/2015 1/23/2015 1/20/2015
Figure2:
1/2/2015 1/3/2015 1/5/2015
1/15/2015 1/16/2015 1/5/2015 abc123
1/15/2015 1/16/2015 1/5/2015 abc345
1/22/2015 1/23/2015 1/20/2015 aab123
1/29/2015 1/30/2015 1/13/2015 cba123
1/29/2015 1/30/2015 1/13/2015 cbb123
1/29/2015 1/30/2015 1/13/2015 cbc432
1/22/2015 1/23/2015 1/20/2015
I appreciate any help, input, suggestion or anything, I'm either overlooking something simple or I don't know it all together but there must be a standard solutions for this.
Thank you!
Bookmarks