Copy/Paste variable length rows

[srfeldman]

I have read several similar posts, but none seem to work for what I'm doing. Seems simple, yet I can't figure it out. I have thousands of rows in a spreadsheet and 150 unique id's in col. A. The rows that follow each unique number are variable. For example, empl. 502 has 26 rows, followed by empl. 316 that has 4 rows. I want to copy 502 to the next 26 rows, then 316 to the 4 rows after 316, and so on for the 150 unique id's and rows that follow. Any help is greatly appreciated. Thanks!

 

[Fluff]

Fluff, great idea using areas, I didn't consider that. That is a much more elegant solution than mine!

And Rick Rothstein' makes things even simpler.