Hello Rahmadi Edi,
Ada cara manual yang simpel banget,
1. Copy datanya
2. Pilih Edit
3. Paste Spesial, Centang "Transpose"
4. Ok, Deh
tapi mesti ati-ati klo data ampe ribuan karena jumlah row excel jauh lebih
banyak dari jumlah kolomnya.
Pengen dapet trik yang lebih canggih ?
gabung dimari gih : [EMAIL PROTECTED]
tempatnya dedengkot excel dimari nieh....
Moga membantu.
Rahmadi, Edi wrote:
> Yang jago excel,
>
> Gw ada problem nih......Ane punya data yang daftarnya secara
> vertikal.Nah persoalannya data tersebut harus tersusun secara
> horizontal.
> Bentuknya datanya seperti ini:
> A1 A2 A3 A4 A5
> B1 abcd 1
> C1 2
> D1 3
>
> Nah data tersebut harus disusun secara horizontal seperti ini :
> A1 A2 A3 A4 A5
> B1 abcd 1 2 3
> C1
> D1
>
>
--
------------------------------------------------------------------------
/ \__ | TRBJ
\__/ \ | ,.-:*'``'*:-.,_,.-.:Trankkinaz:.-.,_,.-:*'``'*:-.,
/ \__/ | "No Single Bullet for Assessing People"
\__/ | ~ Genesis ~
------------------------------------------------------------------------
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/mailplus/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/mailplus/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
