amin, ia semoga saja karena mas ghozi maaf di file lain saya coba yang muncul diawali nya dari NIK istrinya mas
Pada Min, 4 Mar 2018 pada 10:02, ghozi alkatiri [email protected] [belajar-excel]<[email protected]> menulis: Wa fiikum. Insya Allah nanti kalau ada waktu akan saya coba jelaskan bahasa manusianya, mungkin dari mr kid atau lainnya.nanti kita diskusikan sama sama. Wassalam. Ghozi Alkatiri -------------------------------------------- Pada Ming, 4/3/18, Rian Sutarsa [email protected] [belajar-excel] <[email protected]> menulis: Judul: Bls: Re: [belajar-excel] Transpose Data Kepada: [email protected] Tanggal: Minggu, 4 Maret, 2018, 9:10 AM alhamdulillah sukses mas ghozi, terimakasih banyak. baarakallah Pada Min, 4 Mar 2018 pada 8:46, ghozi alkatiri [email protected] [belajar-excel] menulis: Coba formula ini penjelasan bahasa manusianya nanti menyusul tulis formula di B16 copy ke kanan dank e bawah =IF(TRUNC((COLUMN(A:A)-1)/5) Wassalam Ghozi Alkatiri -------------------------------------------- Pada Ming, 4/3/18, Rian Sutarsa [email protected] [belajar-excel] menulis: Judul: Re: [belajar-excel] Transpose Data Kepada: [email protected] Tanggal: Minggu, 4 Maret, 2018, 7:12 AM Mr. Kid ini saya coba update data nya sangat berharap bisa dibantu.terimakasih Pada Minggu, 04 Maret 2018 00:40:39 WIB, 'Mr. Kid' [email protected] [belajar-excel] menulis: Wa'alaikumussalam wr wb Hai Rian, Pertama : Sebaiknya, tabel data disusun sebagai tabel yang baik. Pada contoh data, tabel yang baik adalah dengan kolom NKK yang terisi penuh. Ingat, Excel TIDAK KENAL cells kosong yang memiliki arti 'nilai sama dengan atasnya' atau 'cells kosong ini berisi data seperti isi cells sebelumnya' Jadi, perbaikilah hal ini. Jadi, bagi Excel, data di baris 3 adalah data tanpa nilai NKK. Kedua : Sebaiknya disertakan penjelasan detil tentang kasusnya, disertai contoh data yang mewakili varian dari data. Kemudian disertakan bentuk output hasil kerja manual dari varian data tersebut. Contoh : jika data tersebut adalah data warga disebuah RT, maka ada kemungkinan sebuah NKK berisi 3 orang berisi seorang janda beserta seorang anak perempuan dan ibu dari si wanita janda. Ketiga : Cells bantu pada sisi data atau pada sisi output maupun pada kedua sisi, dapat memudahkan proses penyusunan formula. Contoh terlampir. Wassalamu'alaikum wr wb Kid 2018-03-03 22:37 GMT+07:00 Rian Sutarsa [email protected] [belajar-excel] : Assalamualaikum... selamat malam Mr. Kid dan Master2 BeExcellersaya sudah lihat post2 pertanyaan soal ini sebelumnya hanya saja entah mengapa saya belum bisa aplikasikan ke pe er ini. mohon bantuannya bingung bagaimana jelasinnya.. yang pasti pertanyaan nya bagaimana membuat formula yang sesuai dengan file yang saya lampirkan terimakasih sebelumnya.Wassalamualaikum Wr.Wb. #yiv9825424883 #yiv9825424883 -- #yiv9825424883ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;} #yiv9825424883 #yiv9825424883ygrp-mkp hr { border:1px solid #d8d8d8;} #yiv9825424883 #yiv9825424883ygrp-mkp #yiv9825424883hd { color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;} #yiv9825424883 #yiv9825424883ygrp-mkp #yiv9825424883ads { margin-bottom:10px;} #yiv9825424883 #yiv9825424883ygrp-mkp .yiv9825424883ad { padding:0 0;} #yiv9825424883 #yiv9825424883ygrp-mkp .yiv9825424883ad p { margin:0;} #yiv9825424883 #yiv9825424883ygrp-mkp .yiv9825424883ad a { color:#0000ff;text-decoration:none;} #yiv9825424883 #yiv9825424883ygrp-sponsor #yiv9825424883ygrp-lc { font-family:Arial;} #yiv9825424883 #yiv9825424883ygrp-sponsor #yiv9825424883ygrp-lc #yiv9825424883hd { margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;} #yiv9825424883 #yiv9825424883ygrp-sponsor #yiv9825424883ygrp-lc .yiv9825424883ad { margin-bottom:10px;padding:0 0;} #yiv9825424883 #yiv9825424883actions { font-family:Verdana;font-size:11px;padding:10px 0;} #yiv9825424883 #yiv9825424883activity { background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;} #yiv9825424883 #yiv9825424883activity span { font-weight:700;} #yiv9825424883 #yiv9825424883activity span:first-child { text-transform:uppercase;} #yiv9825424883 #yiv9825424883activity span a { color:#5085b6;text-decoration:none;} #yiv9825424883 #yiv9825424883activity span span { color:#ff7900;} #yiv9825424883 #yiv9825424883activity span .yiv9825424883underline { text-decoration:underline;} #yiv9825424883 .yiv9825424883attach { clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;} #yiv9825424883 .yiv9825424883attach div a { text-decoration:none;} #yiv9825424883 .yiv9825424883attach img { border:none;padding-right:5px;} #yiv9825424883 .yiv9825424883attach label { display:block;margin-bottom:5px;} #yiv9825424883 .yiv9825424883attach label a { text-decoration:none;} #yiv9825424883 blockquote { margin:0 0 0 4px;} #yiv9825424883 .yiv9825424883bold { font-family:Arial;font-size:13px;font-weight:700;} #yiv9825424883 .yiv9825424883bold a { text-decoration:none;} #yiv9825424883 dd.yiv9825424883last p a { font-family:Verdana;font-weight:700;} #yiv9825424883 dd.yiv9825424883last p span { margin-right:10px;font-family:Verdana;font-weight:700;} #yiv9825424883 dd.yiv9825424883last p span.yiv9825424883yshortcuts { margin-right:0;} #yiv9825424883 div.yiv9825424883attach-table div div a { text-decoration:none;} #yiv9825424883 div.yiv9825424883attach-table { width:400px;} #yiv9825424883 div.yiv9825424883file-title a, #yiv9825424883 div.yiv9825424883file-title a:active, #yiv9825424883 div.yiv9825424883file-title a:hover, #yiv9825424883 div.yiv9825424883file-title a:visited { text-decoration:none;} #yiv9825424883 div.yiv9825424883photo-title a, #yiv9825424883 div.yiv9825424883photo-title a:active, #yiv9825424883 div.yiv9825424883photo-title a:hover, #yiv9825424883 div.yiv9825424883photo-title a:visited { text-decoration:none;} #yiv9825424883 div#yiv9825424883ygrp-mlmsg #yiv9825424883ygrp-msg p a span.yiv9825424883yshortcuts { font-family:Verdana;font-size:10px;font-weight:normal;} #yiv9825424883 .yiv9825424883green { color:#628c2a;} #yiv9825424883 .yiv9825424883MsoNormal { margin:0 0 0 0;} #yiv9825424883 o { font-size:0;} #yiv9825424883 #yiv9825424883photos div { float:left;width:72px;} #yiv9825424883 #yiv9825424883photos div div { border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;} #yiv9825424883 #yiv9825424883photos div label { color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;} #yiv9825424883 #yiv9825424883reco-category { font-size:77%;} #yiv9825424883 #yiv9825424883reco-desc { font-size:77%;} #yiv9825424883 .yiv9825424883replbq { margin:4px;} #yiv9825424883 #yiv9825424883ygrp-actbar div a:first-child { margin-right:2px;padding-right:5px;} #yiv9825424883 #yiv9825424883ygrp-mlmsg { font-size:13px;font-family:Arial, helvetica, clean, sans-serif;} #yiv9825424883 #yiv9825424883ygrp-mlmsg table { font-size:inherit;font:100%;} #yiv9825424883 #yiv9825424883ygrp-mlmsg select, #yiv9825424883 input, #yiv9825424883 textarea { font:99% Arial, Helvetica, clean, sans-serif;} #yiv9825424883 #yiv9825424883ygrp-mlmsg pre, #yiv9825424883 code { font:115% monospace;} #yiv9825424883 #yiv9825424883ygrp-mlmsg * { line-height:1.22em;} #yiv9825424883 #yiv9825424883ygrp-mlmsg #yiv9825424883logo { padding-bottom:10px;} #yiv9825424883 #yiv9825424883ygrp-msg p a { font-family:Verdana;} #yiv9825424883 #yiv9825424883ygrp-msg p#yiv9825424883attach-count span { color:#1E66AE;font-weight:700;} #yiv9825424883 #yiv9825424883ygrp-reco #yiv9825424883reco-head { color:#ff7900;font-weight:700;} #yiv9825424883 #yiv9825424883ygrp-reco { margin-bottom:20px;padding:0px;} #yiv9825424883 #yiv9825424883ygrp-sponsor #yiv9825424883ov li a { font-size:130%;text-decoration:none;} #yiv9825424883 #yiv9825424883ygrp-sponsor #yiv9825424883ov li { font-size:77%;list-style-type:square;padding:6px 0;} #yiv9825424883 #yiv9825424883ygrp-sponsor #yiv9825424883ov ul { margin:0;padding:0 0 0 8px;} #yiv9825424883 #yiv9825424883ygrp-text { font-family:Georgia;} #yiv9825424883 #yiv9825424883ygrp-text p { margin:0 0 1em 0;} #yiv9825424883 #yiv9825424883ygrp-text tt { font-size:120%;} #yiv9825424883 #yiv9825424883ygrp-vital ul li:last-child { border-right:none !important; } #yiv9825424883 #yiv9693302017 #yiv9693302017 -- #yiv9693302017ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9693302017 #yiv9693302017ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9693302017 #yiv9693302017ygrp-mkp #yiv9693302017hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9693302017 #yiv9693302017ygrp-mkp #yiv9693302017ads {margin-bottom:10px;}#yiv9693302017 #yiv9693302017ygrp-mkp .yiv9693302017ad {padding:0 0;}#yiv9693302017 #yiv9693302017ygrp-mkp .yiv9693302017ad p {margin:0;}#yiv9693302017 #yiv9693302017ygrp-mkp .yiv9693302017ad a {color:#0000ff;text-decoration:none;}#yiv9693302017 #yiv9693302017ygrp-sponsor #yiv9693302017ygrp-lc {font-family:Arial;}#yiv9693302017 #yiv9693302017ygrp-sponsor #yiv9693302017ygrp-lc #yiv9693302017hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9693302017 #yiv9693302017ygrp-sponsor #yiv9693302017ygrp-lc .yiv9693302017ad {margin-bottom:10px;padding:0 0;}#yiv9693302017 #yiv9693302017actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9693302017 #yiv9693302017activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9693302017 #yiv9693302017activity span {font-weight:700;}#yiv9693302017 #yiv9693302017activity span:first-child {text-transform:uppercase;}#yiv9693302017 #yiv9693302017activity span a {color:#5085b6;text-decoration:none;}#yiv9693302017 #yiv9693302017activity span span {color:#ff7900;}#yiv9693302017 #yiv9693302017activity span .yiv9693302017underline {text-decoration:underline;}#yiv9693302017 .yiv9693302017attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9693302017 .yiv9693302017attach div a {text-decoration:none;}#yiv9693302017 .yiv9693302017attach img {border:none;padding-right:5px;}#yiv9693302017 .yiv9693302017attach label {display:block;margin-bottom:5px;}#yiv9693302017 .yiv9693302017attach label a {text-decoration:none;}#yiv9693302017 blockquote {margin:0 0 0 4px;}#yiv9693302017 .yiv9693302017bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9693302017 .yiv9693302017bold a {text-decoration:none;}#yiv9693302017 dd.yiv9693302017last p a {font-family:Verdana;font-weight:700;}#yiv9693302017 dd.yiv9693302017last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9693302017 dd.yiv9693302017last p span.yiv9693302017yshortcuts {margin-right:0;}#yiv9693302017 div.yiv9693302017attach-table div div a {text-decoration:none;}#yiv9693302017 div...yiv9693302017attach-table {width:400px;}#yiv9693302017 div.yiv9693302017file-title a, #yiv9693302017 div.yiv9693302017file-title a:active, #yiv9693302017 div.yiv9693302017file-title a:hover, #yiv9693302017 div.yiv9693302017file-title a:visited {text-decoration:none;}#yiv9693302017 div.yiv9693302017photo-title a, #yiv9693302017 div.yiv9693302017photo-title a:active, #yiv9693302017 div.yiv9693302017photo-title a:hover, #yiv9693302017 div.yiv9693302017photo-title a:visited {text-decoration:none;}#yiv9693302017 div#yiv9693302017ygrp-mlmsg #yiv9693302017ygrp-msg p a span.yiv9693302017yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9693302017 .yiv9693302017green {color:#628c2a;}#yiv9693302017 .yiv9693302017MsoNormal {margin:0 0 0 0;}#yiv9693302017 o {font-size:0;}#yiv9693302017 #yiv9693302017photos div {float:left;width:72px;}#yiv9693302017 #yiv9693302017photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv9693302017 #yiv9693302017photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9693302017 #yiv9693302017reco-category {font-size:77%;}#yiv9693302017 #yiv9693302017reco-desc {font-size:77%;}#yiv9693302017 .yiv9693302017replbq {margin:4px;}#yiv9693302017 #yiv9693302017ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9693302017 #yiv9693302017ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9693302017 #yiv9693302017ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9693302017 #yiv9693302017ygrp-mlmsg select, #yiv9693302017 input, #yiv9693302017 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9693302017 #yiv9693302017ygrp-mlmsg pre, #yiv9693302017 code {font:115% monospace;}#yiv9693302017 #yiv9693302017ygrp-mlmsg * {line-height:1.22em;}#yiv9693302017 #yiv9693302017ygrp-mlmsg #yiv9693302017logo {padding-bottom:10px;}#yiv9693302017 #yiv9693302017ygrp-msg p a {font-family:Verdana;}#yiv9693302017 #yiv9693302017ygrp-msg p#yiv9693302017attach-count span {color:#1E66AE;font-weight:700;}#yiv9693302017 #yiv9693302017ygrp-reco #yiv9693302017reco-head {color:#ff7900;font-weight:700;}#yiv9693302017 #yiv9693302017ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9693302017 #yiv9693302017ygrp-sponsor #yiv9693302017ov li a {font-size:130%;text-decoration:none;}#yiv9693302017 #yiv9693302017ygrp-sponsor #yiv9693302017ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9693302017 #yiv9693302017ygrp-sponsor #yiv9693302017ov ul {margin:0;padding:0 0 0 8px;}#yiv9693302017 #yiv9693302017ygrp-text {font-family:Georgia;}#yiv9693302017 #yiv9693302017ygrp-text p {margin:0 0 1em 0;}#yiv9693302017 #yiv9693302017ygrp-text tt {font-size:120%;}#yiv9693302017 #yiv9693302017ygrp-vital ul li:last-child {border-right:none !important;}#yiv9693302017
