excel - Convert column layout into row layout -

how can move columns rows leave of data alone in rows?

for example:

click on f2, alt+d, p, select multiple consolidation ranges, next >, select i create page fields, next >, in range: enter: a2:d6, add, next >, finish, double-click on j10, select rows2:7 , drag down row14. delete rows2:7. click on a1, right-click, table, convert range, yes, enter "product name" , blank b1:c1. format suit.