column to line

[knobi]

Hello is it possible to do the following with excel 2010 :

[COLOR="Red"]input :[/COLOR]
[B]     col1 col2 col3 col4 col5 col6 col7...[/B]
[B]lin1[/B] val1 val2 val3 val4
[B]lin2[/B]      val5 val6
[B]lin3[/B]      val7 val8 val9 val10
[B]lin4[/B] val1 val2 val3 val4
[B]lin5[/B]      val5 val6
[B]lin6[/B]      val7
  .
  .
  . 
(100 times)

[COLOR="Red"]output:[/COLOR]
[B]     col1 col2 col3 col4 col5 col6 col7 col8 col9 col10...[/B]
[B]lin1[/B] val1 val2 val3 val4 val5 val6 val7 val8 val9 val10
[B]lin2[/B] val1 val2 val3 val4 val5 val6 val7

the problem is... this group of values (input) repeats 100 times... and they also may vary the amount of values in the line (up to 10) and the amount of lines (up to 80)...

is there any "easy" or "near to easy" way to do this without go line by line formatting this ?

 

[Sektor]

Are col1 and lin1 etc. real cells?

 

[knobi]

COL1 = column A
COL2 = column B...

LIN1 = line 1
LIN2 = line 2...