This video will show you how to filter column headers with conditions, and how we apply List.Select(), Table.ColumnNames(), Text.Contains(), Text.StartsWith(), Text.EndsWith() with examples.
Topic:
0:00 - Intro
0:45 - Filter Column Headers Explained
1:26 - Step 1 - Table.ColumnNames()
1:49 - Step 2 - List.Select() + Text.Contains()
2.32 - Step 3 - Apply Step 2 + Step 3 to Table.SelectColumns() / Table.RemoveColumns
2:58 - Update Keyword
3:20 - Text.EndsWith()
3:30 - Text.StartsWith()
3:36 - Bonus Example - Table.Unpivot
4:00 - Wrap up
Workbook:
[ Ссылка ]
![](https://s2.save4k.ru/pic/77wJuonliwE/maxresdefault.jpg)