I have thousands of rows of parsed text in single rows. What I have
been asked to do is now take part of each row (starting at column F)
and data in each of the next cells (the number of cells varies from row
to row) and copy if down into inserrted rows.

So instead of

Person1 Name Date Comment1 Comment2 Comment3 Comment4
Person2 Name Date Comment2 Comment2 Comment3
(the number of columns varies one I get to the first comment column)


They want it to look like this:

Person1 Name Date Comment1
Person1 Name Date Comment2
Person1 Name Date Comment3
Person1 Name Date Comment4
Person2 Name Date Comment1
Person2 Name Date Comment2
Person2 Name Date Comment3
etc...

Any ideas? I have thousands of rows already filled in as in the example
at the top.

Any macro recommendations would be greatefully appreciated.