I have an array of 100 columns X 15 rows A1:CV15

Each column contains the words of a single line from a document up to a
maximum of 15.

Some of 15 end cells are blanks since not all lines are equal in length.

It is required to index (Book Index) all these words into a single column
with the line numbers from which it came into a column alongside. That is we
need to know the line number of each word in the original document.

The tricky bit here is how to index the line numbers alongside the words
before
using VBA code to move sequentially all the columns into one one.