Compare column number of a cell with the last cell column number in a loop

Originally Posted by Marc L

Join & Split are like Cats & Dogs, Sun & Moon or Yin & Yang :
one creates a string with a separator from an array,
the other creates an array from a string cut by a separator.

Join([{"Felix","The","Cat"}], "-") = "Felix-The-Cat"

Split("Danny-The-Dog", "-") = [{"Danny","The","Dog"}]


The worksheet function INDEX extracts - in this case - a row from a group of rows …

Thanks for the explanation Mark! I believe this should help me get started