Re: Need help from an Excel guru

[John Posada <jposada99 -at- gmail -dot- com>]

> In the course of the project I would worry that some of the cells in the
> table might contain "other" data such as comments, or notes describing
> exceptional aspects of the data in other cells. This is a very common
> misuse of tabular data. Here's what I mean:


Thanks, Peter, but you are WAY overthinking this :-)

The table is a dump of the links on each page of my 1700+ web page
external knowledgebase. The first column is the URL of the page and
the second column is the URLs of the links on that page.
Unfortunately, the tool I had to use for the extraction would list the
source page as a heading and not for each line.

I want to have the page URL adjacent to each link so I can run some
filtering and run some an Excel Pivot Table for some analysis I'm
doing.

But thanks

-- 
John Posada
http://jposada.zenfolio.com/
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

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