Lesson 113 Gỡ các cột trống trong Power Query

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=im98ef2-NPw

#query #remove #blank • #GBE #GreenBox #Education #tips #excel #hoc #hieuqua #study #tinhocvanphong #manage #automate #kynangquanly #tudonghoa • Advance Editor of PQ below: • let • Source = Excel.CurrentWorkbook(){[Name= RemoveBlankCol ]}[Content], • # Changed Type = Table.TransformColumnTypes(Source,{{ Ngày , type datetime}, { Sản phẩm , type text}, { Số lượng , Int64.Type}, { Giá , Int64.Type}, { Chi phí , type any}, { Doanh thu , Int64.Type}, { Lợi nhuận , type any}}), • # Added Index = Table.AddIndexColumn(# Changed Type , Index , 0, 1, Int64.Type), • # Unpivoted Other Columns = Table.UnpivotOtherColumns(# Added Index , { Index }, Attribute , Value ), • # Pivoted Column = Table.Pivot(# Unpivoted Other Columns , List.Distinct(# Unpivoted Other Columns [Attribute]), Attribute , Value ), • # Removed Columns = Table.RemoveColumns(# Pivoted Column ,{ Index }) • in • # Removed Columns • Website: http://greenbox.edu.vn/ • Facebook: / greenbox.edu.vn

#############################

New on site