Hello,
I have a list of addresses in Column A with 11 blank cells in between each address. I'd like the addresses in Column A to repeat themselves in Column B, but I need the blank cells to be replaced with the addresses from Column A so that each address is copied in 12 consecutive rows in Column B. Please see the attached example workbook to see what I'm looking for. Thanks.
Try this in B2 and filled down
=IF(A2="",B1,A2)
Also, if your goal is for the original data in column A to be filled in..
Highlight column A (beginning in row 2)
Press CTRL + G
Click Special
Select Blanks
Click OK
Press =
Press UP Arrow
Press CTRL + ENTER
Last edited by Jonmo1; 12-03-2013 at 04:10 PM.
Hi,
One way
B2 copied down
Formula:
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thanks Richard, that worked well.
Glad to have helped.
Personally I prefer jonmo's second offering which I'd completely forgotten about.
It's not a very well known technique but is rather slick and more efficient for this particular requirement.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks