Hi All, I need a macro that will duplicate rows based on the value in cell A.

Here is my starting data:
Qty Item# Description
2 89825 Sham Qn Sam
2 85415 Sham Qn Biscotti
4 94888 Sham Qn Baroque

And here's the needed result:
Qty Item# Description
2 89825 Sham Qn Sam
2 89825 Sham Qn Sam
2 85415 Sham Qn Biscotti
2 85415 Sham Qn Biscotti
4 94888 Sham Qn Baroque
4 94888 Sham Qn Baroque
4 94888 Sham Qn Baroque
4 94888 Sham Qn Baroque

Any help would be greatly appreciated!

Thanks