transpose berkriteria

[odong nando]

hai rekan sekalian,

mohon bantuan utk kasus seputar transpose namun berkriteria, biasanya saya pake formula filer sederhana, seperti terlampir, tp kok ahir2 ini saya males banget bwt ngetik formula, saya coba pake pivot table, krn keterbatasan ilmu sy blm bisa menjadi format yang di inginkan, adakah solusinya selain formula filtring yg sudah sy gunakan, seperti terlampir

terimakasih

odong nando

[hendrik karnadi]

Mas Odong,

Sdh coba pakai Power Query ?

Salam,

HK

Sent from Yahoo Mail on Android

--
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/CAGZ5tN552LO3wt0zHJsajYDAkb---yr7EeNfgWUUai09weKrRQ%40mail.gmail.com.

[odong nando]

hai pak HK

sudah sy coba tp mentok, tidak membuahkan hasil...

mungkin p HK bisa bimbing saya menyelesaikan masalah ini...

To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/1855905365.1956199.1614166072472%40mail.yahoo.com.

[Mr. Kid]

Gimana kalau jalan-jalan kesini. Sapa tahu gak kejauhan tersesatnya.

;)

To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAGZ5tN58U703k3d-M_eUqEKV%2B4SWgazETGtkRPOo-CqHOPwN8A%40mail.gmail.com.

[odong nando]

mantafffff...

harus di pelajari ini...

tengkiyu bos kid...

To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAOiZkPsx-3NiPi7JiG0vgH9EC%3DiFwkt-_WpAbmQmW8ZYp09NhA%40mail.gmail.com.

[iqba...@gmail.com]

Wedew…. Udah jadi youtuber ini,

Jangan lupa like, subrek and share ya…..

To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAOiZkPsx-3NiPi7JiG0vgH9EC%3DiFwkt-_WpAbmQmW8ZYp09NhA%40mail.gmail.com.

[Mr. Kid]

Ngetik itu capek n susah milih bahasa manusianya.

Lebih gampang asal ngoceh.

Hahaha

Sent from my smart enough phone

[iqba...@gmail.com]

Udah ada 2 youtuber ini di belajar excel.

1. Mr Hendrik Karnadi
2. Mr Kid.

 

Aku buat channel juga di youtube :

https://www.youtube.com/channel/UCO0q6JIcBmBJZQhHJ3ja-KA/videos

 

hahahahahahaha…. Kek nya memang lebih enak klo asal ngoceh.

Ntar habis selesai study aku upload juga lah….

To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/81B508D9-2D06-4F05-A5F9-6BBBA5DF6F36%40gmail.com.

[hendrik karnadi]

Terima kasih mas Iqbal.

Salam,

HK

Sent from Yahoo Mail on Android

https://groups.google.com/d/msgid/milis-belajar-excel/004e01d70cab%24377ae1e0%24a670a5a0%24%40gmail.com

.

[Mr. Kid]

hahaha...

oh lagi study ya...

moga2 lancar ipk empat 

terus naik pangkat

To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/004e01d70cab%24377ae1e0%24a670a5a0%24%40gmail.com.

[zainul ulum]

aku sudah subcribed..

kalo tanya2 di miliat atau di kolom komentar yourtube?

maturnuwun,

_zainul

To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/81B508D9-2D06-4F05-A5F9-6BBBA5DF6F36%40gmail.com.

[Mr. Kid]

boleh dimana saja mas zain
Kalau di-milis, bisa dibantu rekan BeExceller dalam menjawab. Bisa jadi lebih cepat dapat solusi.

Kalau di-youtube, bisanya juga saya reply di-comment, dan nunggu ada banyak yang nge-like comment di-youtube tadi baru diusahakan dibikin pidio-nya

Thanks

To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CADEWuOPVLErsNo%2BCdFg5BS7FPqKiiKyL%2BqsVceuFgstATOpv2Q%40mail.gmail.com.

[iqba...@gmail.com]

Aamiin…

Matur suwun doa nya MasKid

Sukses juga buat keluarga milis ini.

[Mr. Kid]

gimana kabarnya yang lagi study nih... piye rasanya study online dari masuk sampai lulus ?

wkwkwk... 

To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/003f01d70e59%24b8bc10d0%242a343270%24%40gmail.com.

[iqba...@gmail.com]

Alhamdulillah Mas sehat,

Umur tidak bisa membohongi iki…. Lebih berat menjalani study online disbanding offline…

Wkwkwkwkwkwk…

Sejauh mata memandang cumin laptop and mic… ora onok seger segere blas…

 

xixixiix

To view this discussion on the web visit https://groups.google.com/d/msgid/milis-belajar-excel/CAOiZkPspOAOD%2Bv00E7gQEHazsLo9r7-0HgjYDXUTXP1HmhzOow%40mail.gmail.com.