Transpose 2 separate blocks of info into 1 row.

Hello to all,

I have been sitting here trying to figure out a coding to rearrange from file. My spreadsheet is as follows...

product title,
stat1:info,
stat2:info, price title, quality title, set1title, set2 title, set3 title,
stat3:info, price #, quality #, set #, set #, set #,
stat4:info,
stat5:info,
stat6:info,
stat7:info,
stat8:info,

product title,
stat1:info,
stat2:info, price title, quality title, set1title, set2 title, set 3 title,
stat3:info, price #, quality #, set #, set #, set #,
stat4:info,
stat5:info,
stat6:info,
stat7:info,
stat8:info,
and I need it to look as follows

product title, stat1:info, stat2 :info, stat3 :info, stat4 :info, stat5 :info, stat6 :info, stat7 :info, stat8:info, price title: price#, quality title: quality#, set1title:set#, set2 title:set#, set3 title:set#,
product title, stat1:info, stat2 :info, stat3 :info, stat4 :info, stat5 :info, stat6 :info, stat7 :info, stat8:info, price title: price#, quality title: quality#, set1title:set#, set2 title:set#, set3 title:set#,

Each COMMA represents a cell by itself. The example shows the exact amount of columns and rows for each cell of info.

The one block of information needs to be one row going across the top of the worksheet and so on with the all of the second block of information becoming the second row of information. I have a code to make the first column transpose all into a row but haven't figured out a way to add on the information in the middle, combine the content in the cells in the middle and then list them behind the information in the row at the top. PLLEEEAASSEEE someone help me! I have alot of worksheets similar to this that all of the products informaton needs to be in one row. Thank you so much in advance for all of your assistance. Below is the coding that I have to make the 1st column read every 10 cells and make the information into rows.

[#}

Please Login or Register  to view this content.

[#]

Thank you all again!

James

Yes all of my documents in this particular case comes exactly that way. Here's an example of the workbook and what I need it to look like. Thanks for your assistance.