I have a sheet that has been setup that shows a list of documents in one
cloumn and 4 rows are dedicated to indicating reference documents. ie

drawing 1, desc 1, desc2, ref1, ref2, ref3, ref4

where ',' represents a different column.

I want to convert this to the following format

drawing 1, desc 1, desc 2, ref1
drawing 1, desc 1, desc 2, ref2
drawing 1, desc 1, desc 2, ref3
drawing 1, desc 1, desc 2, ref4


Any ideas??