Need help from an Excel guru

[John Posada <jposada01 -at- yahoo -dot- com>]

Hi, guys...long time...

I find myself with a task where I have an Excel spreadsheet with about 5,000
rows. It is a database of URLs from my knowledgebase.

It looks similar to the following:


xxxxx      erergkerg
               juwe
               ejrhghjkerg
zzzzz      ueeefjvbhfb
               jwerfjerjef
               erfpiquer
yyyyy      ehqerf
               wjkf;kjqbb
               kjkf;kjb

You get the idea.

I want to automate the process of copying each string in column one to each
row below it until the value changes, then copy that one until it changes,
to the end.

I would end up with:

xxxxx      erergkerg
xxxxx      juwe
xxxxx      ejrhghjkerg
zzzzz      ueeefjvbhfb
zzzzz      jwerfjerjef
zzzzz      erfpiquer
yyyyy      ehqerf
yyyyy      wjkf;kjqbb
yyyyy      kjkf;kjb

I'm aware that I can highlight the string and all the empty ones below it
and press CTRL-d, but I have about 1600 sets. Is there was a way automate
it?

Thanks

-- 
John Posada
Senior Technical Writer
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Create and publish documentation through multiple channels with Doc-To-Help. 
Choose your authoring formats and get any output you may need. Try 
Doc-To-Help, now with MS SharePoint integration, free for 30-days. 
http://www.doctohelp.com

---
You are currently subscribed to TECHWR-L as archive -at- web -dot- techwr-l -dot- com -dot- 

To unsubscribe send a blank email to 
techwr-l-unsubscribe -at- lists -dot- techwr-l -dot- com
or visit http://lists.techwr-l.com/mailman/options/techwr-l/archive%40web.techwr-l.com


To subscribe, send a blank email to techwr-l-join -at- lists -dot- techwr-l -dot- com

Send administrative questions to admin -at- techwr-l -dot- com -dot-  Visit
http://www.techwr-l.com/ for more resources and info. 

Please move off-topic discussions to the Chat list, at:
http://lists.techwr-l.com/mailman/listinfo/techwr-l-chat