Re: Need help from an Excel guru

[Tony Chung <tonyc -at- tonychung -dot- ca>]

Hi John,

The quick and dirty would be to copy this formula into the last
column, then copy the column and paste as values over the first
column:

=if(A2="",A1,A2)

Let the cell reference change to be relative to the current row.

-Tony



On 2010-12-15, at 18:00, John Posada <jposada01 -at- yahoo -dot- com> wrote:

> 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 tonyc -at- tonychung -dot- ca -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/tonyc%40tonychung.ca
>
>
> 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
>
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

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