$sheet->Cells(10,5)->PasteSpecial(
  {Paste => xlAll,
   Operation => xlNone,
   SkipBlanks =>  0,
   Transpose => 1
  });