I am trying to do the following with no luck. Please Help!!!!!

Example:
original data
A B C D E F G H I
123 more info more info Brown Black Red Purple
456 other stuff other stuff Orange White Yellow


I need it to look like this
A B C D E F
123 more info more info Brown
123 more info more info Black
123 more info more info Red
123 more info more info Purple
456 other stuff other stuff Orange
456 other stuff other stuff White
456 other stuff other stuff Yellow


Also, with some of my attempts. I have gotten the data to paste but
some of it has #value! in the cell instead of data. This is happening
on the cells with a lot of data.

Any assistance would be greatly appriciated

Thanks,
-KIM-