How can I summarise values which are stored in a row, ignoring blank cells?

[hmm]

Well, I've tried searching the archive with Google, but can't seem to find
what I'm after! So here goes:

How can I show only the values stored in a row (these values are text),
summarised into adjacent columns, ignoring blank cells in between?

************
The background:

I'm using Excel as a matrix of connected web pages arranged in a sequence.
The rows and columns have the same headings, and by reading across the rows
I can record a '1' for a link forwards in the sequence (and the columns will
then show preceding linked pages)

E.g
bananas apples oranges lemons

bananas
apples
oranges
lemons

If 'bananas' links to 'apples' and 'lemons' only, the row for bananas would
read:

0 1 0 1

I've then used an IF function to look up column heading if the cell value is
= 1 else return a blank...

....so my row reads bananas: [blank] apples [blank] lemons

And what I want to display is: apples lemons

************

Is there a neat function I'm overlooking, or should I put my VBA hat on?

Many thanks in advance,

Gavnosis

 

[Gavnosis]

Scrub that!

I've found a tutorial at http://www.cpearson.com/excel/noblanks.htm (Thanks
Chip!)

G