Power Query 5. Removing Rows (Deleting Rows)
Sample file: https://blog.naver.com/pig075/2223292...
Mania Official Open KakaoTalk Chatroom: https://open.kakao.com/o/gLti8djb
Many skilled users are in the chatroom. Come ask questions and hone your Excel skills.
Individual inquiries and requests: [email protected]
(Online remote lectures, on-site lectures, small-scale private tutoring for certifications, customized Excel data design and management for companies)
Timestamp
00:00 Video starts
00:27 Row reduction menu explanation
01:50 Employee list normalization explanation
03:55 Power Query editor starts
04:10 Remove parent rows
04:30 Remove child rows
05:20 Fill in
05:40 Replace values
06:09 Copy query
06:25 Alternately delete rows
08:37 Merge queries
12:27 Remove duplicates
15:07 Remove blank rows