Bisa mas,

Pakai fungsi "=OFFSET(...)"
contohnya terlampir di attachment

Iseng


From: mohammad zamroni <[email protected]>
To: [email protected]
Sent: Thursday, May 3, 2012 7:36 PM
Subject: ]] XL-mania [[ Mengubah File Vertical to Horizontal

Dear Para Master,
Mohon bantuannya utk dicarikan solusi sbb: apakah menggunakan Transpose ? atau bagaimna??

Inline image 1
--
Mohammad Zamroni





Attachment: Transpose sederhana.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Kirim email ke