move column data to different row

[duwell81]

I have a spreadsheet with rows of product data with header rows above the data throughout the worksheet that highlights the machines or printers my products are used in.
the machine headers are in column 1 with all other columns blank
the product data or printing supplies that go in the machine are listed underneath the machine header starting in column 1 and cover 6 to 7 other pieces of data in the columns 2 to 7
I want to take the Machine headers in Column 1 and move them to column 8 in the row below next to the first product and copy and paste the header into all the other column 8 rows that these machines go with.
Until the next Machine Header is found in column one (all other columns blank)
Secondly I want to erase the row that the Machine Header row was in after it is moved next to all the products it goes with. This will allow me sort the database more efficiently

ex.
Before Look
C1
Machine Header1
Product1........Column7
Product2........Column7
Product3.........Column7
Machine Header2
Product1........Column7
Product2........Column7
After Look

Product1........Column7 Machine1
Product2........Column7 Machine1
Product3.........Column7 Machine1
Product1........Column7 Machine2
Product2........Column7 ''
and so on.
Thanks,
Wayne