Duplicating partial rows.

[Cyberpawz]

I have some data that has been imported from elsewhere. the sheet as you see can be solved mainly by moving the data from F and G up a single row, the problem comes where I need on row 10 through 13, which will be after the data has been moved up one will be 10 through 12. I need to have it where the data on 9 through cells A through D copy down till the end of row F. Then continue down and do the same if any other rows have the same "problem"...

I hope I am being clear, if not please ask, but can someone help me here? I thought about using the concept of till the end copy, but I can see that not working because not all cells need it... it only needs to happen when the opportunity arises.

Attached is the sheet in hopes to clarify the problem.

[rvasquez]

Hello there,

I'd like to help you but I'm a little confused as to what you are needing. Can you explain a little further?

Thanks!