convert data into a list in excel

Avg Bid (EUR)
Project Budget (EUR)
€30 - €250

Project Description:
I have an excel file with info on hotels (column F) and rooms (CE)
this info need to be in the same line, all attached (no blanks). Hotel info on columns named check 1 to 76, room info on columns named prod 1 to 7
I have done lines 1 to 16 as an example, but I need all lines done (about 3000).
this would be a simple VBA script.

Skills required:
Data Entry, Data Processing, Excel
Additional Files: DB+camping_texte.xlsm
About the employer:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

€ 222
in 3 days
€ 63
in 2 days
€ 37
in 0 days
Hire bharanisrihari
€ 34
in 1 days
€ 38
in 1 days
€ 34
in 1 days
Hire svteam
€ 55
in 2 days
€ 55
in 5 days
€ 43
in 3 days
Hire DrTech76
€ 30
in 1 days