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.