# List & replicate cells A1,B1,C1 based on non blank cells D1:BK1, same thing down to row20

1. ## List & replicate cells A1,B1,C1 based on non blank cells D1:BK1, same thing down to row20

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!

2. ## Re: List & replicate cells A1,B1,C1 based on non blank cells D1:BK1, same thing down to ro

Welcome to the board! My brain is sluggish this morning, so I bailed on trying to do this with formulas, but the following procedure should work:

``Please Login or Register  to view this content.``
See the attached for added clarity

There are currently 1 users browsing this thread. (0 members and 1 guests)