Fill in the blanks in between the rows


February 11th, 2013 by admin admin

You downloaded a contact list containing names and email addresses from your company system. A simplified example of the list is shown below.

In the list, you discovered that some names are missing from column B. In your folder, you have a backup copy which allows you to find all the missing names. Using VLOOKUP, you can quickly place those names in a separate column. However, that is far from perfect. You would like to merge the names in column D into Column B. Most people would have done it manually. If it is just a few names, you can manually do a few copy and paste and the job would have completed in less than a minute. But if there are hundreds of them,

then this solution is a time saver. Watch how it is done in this video.

[jwplayer mediaid="1535"]

 

Leave a Reply

You must be logged in to post a comment.

s2Member®