Fwd: Need help from an Excel guru

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

I sent this directly to John but it might have gotten trapped in his spam
blocker.

-Tony



Begin forwarded message:

*From:* Tony Chung <tonyc -at- tonychung -dot- ca>
*Date:* 15 December, 2010 18:40:25 PST
*To:* John Posada <jposada01 -at- yahoo -dot- com>
*Cc:* "List, Techwriter" <techwr-l -at- lists -dot- techwr-l -dot- com>
*Subject:* *Re: Need help from an Excel guru*

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