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??

--
Mohammad Zamroni
Mohon bantuannya utk dicarikan solusi sbb: apakah menggunakan Transpose ? atau bagaimna??

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

