Tanya Dong Suhu,

Adi Tahajudin

unread,

Feb 3, 2021, 7:41:32 AM2/3/21

to milis Belajar-Excel

Mau Merubah Tampilan Data,
Klo dikit kaya di contoh yang saya lampirin sih bisa Paste Spesial Tranpose, tapi data yang mau saya kerjakan Banyak banget. Hehehe

Berikut lampirannya, Mohon bantu di tengok.

Terimakasih Banyak Suhu,

Mr. Kid

unread,

Feb 3, 2021, 10:51:46 AM2/3/21

to milis Belajar-Excel

hmmm...

kok belum nemu file lampirannya ya...

hayo tebak... ada dimanakah dia ?

--
You received this message because you are subscribed to the Google Groups "milis Belajar-Excel" group.
To unsubscribe from this group and stop receiving emails from it, send an email to milis-belajar-e...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/ed1071e0-5896-45cb-ab98-373d0f6f8cfen%40googlegroups.com.

Adi Tahajudin

unread,

Feb 4, 2021, 12:54:56 AM2/4/21

to Mr. Kid, milis Belajar-Excel

Hehehe
Kesangkut sepertinya.

To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAOiZkPuxX5R82CjgZ-5hTnmczENn7aWo2MJi%3D2CZs99y%2BGMMgQ%40mail.gmail.com.

Merubah Tampilan Data.xlsx

odong nando

unread,

Feb 4, 2021, 9:29:48 AM2/4/21

to milis Belajar-Excel

hai adi,

coba dulu deh di copy semua data yang mau di ubah. dalam hal ini blok B5 s.d I10, setelah itu klik copy, pilih tempat destinasi hasil, klik kanan paste spesial value cek list bagian transpose....

To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAG%3DCbJB7vp9EFe0866Avn6RpSVD6Wanfky2EPPFpBo3KE%2BuNMw%40mail.gmail.com.

Reply all

Reply to author

Forward