Copy rows when value matches a value in another column

ok, I'll give it some more thought and see what I can do...

I have it!!

I did copy it for the entire sheet but the file is over the max upload limit. Please download the attachment then do a fill down to cell 3840, after that click on the filter dropdown arrow, scroll to the bottom of the list and un-tick blanks.

That should solve it