Remove Rows & Columns With Less Known Power Query Functions, Table.AlternateRows - Challenge 116
In this video, we solve Challenge 116: Removing rows and columns in Power Query using the less-known Table.AlternateRows function. Learn how to ignore the first row and column, and then remove every other row and column in the dataset. This tutorial is ideal for mastering efficient table manipulations in Power Query!
00:00 Introduction
01:02 Power Query Editor
02:40 Fourth argument of function