Dear Mas Ulum
Monggo di telisik cara versi ke dua
Thanks
Best Regards
Muhammad Iqbal
+62890909010/0811101854
From: belajar-excel@yahoogroups.com
Sent: Wednesday, October 23, 2019 12:59 PM
To: belajar-excel@yahoogroups.com
Subject: [belajar-excel] Transform Table dengan
pilih kolom X, Y, Z -> menu transform -> unpivot columns -> pilih unpivot
columns -> edit formula, ubah Attribute jadi Coord dan Vaue jadi XYZ ->
enter
On Wed, Oct 23, 2019 at 7:42 PM Zainul Ulum zainul_u...@yahoo.com
[belajar-excel] wrote:
>
>
> Rekan Be-Excel,
>
>
>
> Saya ingin merubah table
Rekan Be-Excel,
Saya ingin merubah table dengan bantuan Power Query.
Table semula:
-
ID|X |Y |Z |DESC |STATUS
-
1A|23|34|100|CP-01|NEW
Tabel yang diinginkan :
-
ID|DESC |STATUS|Coord|XYZ
-
3 matches
Mail list logo