Which formula (or combination of formulas) will allow me to use specific columns/rows for new table

When using Excel 2010, I have a table where I need to turn the data found in B2-I2 (merged) into column 1, B3-I3(merged) into column 2, B4 into column 3, and G4 into clumn 4.

The issue I have is I don't know which formula (or combination of formulas) will allow me to use specific columns and specific rows to build a new table.
here is an example of the data

blank row*
Data Title(1)
Table Title(2)
cell1(3) cell2 cell3 cell4 cell5 cell6(4)
cell1(3) cell2 cell3 cell4 cell5 cell6(4)
cell1(3) cell2 cell3 cell4 cell5 cell6(4)
cell1(3) cell2 cell3 cell4 cell5 cell6(4)
blank row*
Table Title(2)
cell1(3) cell2 cell3 cell4 cell5 cell6(4)
cell1(3) cell2 cell3 cell4 cell5 cell6(4)
cell1(3) cell2 cell3 cell4 cell5 cell6(4)
cell1(3) cell2 cell3 cell4 cell5 cell6(4)
blank row*
Table Title(2)
cell1(3) cell2 cell3 cell4 cell5 cell6(4)
cell1(3) cell2 cell3 cell4 cell5 cell6(4)
cell1(3) cell2 cell3 cell4 cell5 cell6(4)
cell1(3) cell2 cell3 cell4 cell5 cell6(4)
Gilberto525
Asked Dec 28, 2012

TIP: If it's not your answer to this question, please click "Leave a Comment" button under the question to communicate with the question owner.

Categories