Hello all, and thanks in advance:

I have an excel file that this obtained of a Word table (text to table,
select copy and past in excel). There is only text in cells. One word every
cell. I want to know like I can select a word determined in all the cells
in which it appears and obtain a diagram of her on the basis of its value
of row. That is to say, if the word is "pine" and in the first column it
occupies the A51 cell and in the second B70 and the third C16 and the
fourth D34, as I can select "pine" and to obtain its chart 51-70-16-34 in a
line.

I have the file with only text in cells as the same:

A1 column: pine, fir, tree, fresal, house, rivet, basket, bear, grandma.
A2 column: basket, pine, fresal, tree, rivet, bear, grandma, fir, house.
A3 column: grandma, tree, basket, rivet, pine, bear, fresal, fir, house.
A4 column: tree, pine, house, rivet, fresal, bear, fir, grandma, basket.


The words don´t repeat in the same column. I have a table of 150 columns.
In this case the chart for "pine": 1-2-5-2, for "fir": 2-8-8-7 and for
"grandma": 9-7-1-8 (the number of the row)

Not if I explain myself very well. I need it for a special text analisys.


Thank you very much by the aid.