How to Sum Odd and Even Rows Separately - Power Query Challenge 96
Автор: How to Learn Excel
Загружено: 2025-10-11
Просмотров: 238
How to Sum Odd and Even Rows Separately - Power Query Challenge 96
Learn how to group every other row in Power Query — odd vs even — using two smart techniques.
First, we’ll build it step by step with an Index column.
Then I’ll show you a one-line trick using the underrated List.Alternate function.
This is one of those “why didn’t I know this earlier?” Power Query moments — perfect for anyone who wants cleaner, faster data transformations.
📘 What You’ll Learn
How to group odd and even rows in Power Query
When to use Index vs List functions
How List.Alternate selects every other value
Building custom tables with #table
Explore more tutorials:
🎥 Power Query Challenges Playlist:
• Power Query: Challenges
🎥 Dynamic Array Formulas Playlist:
• Modern Excel Challenges
#PowerQuery #ExcelTips #HowToLearnExcel
Links:
Challenge Author: Omid Motamedisedeh
LinkedIn: / omidmot
Challenge Post: / omidmot_exclude-powerabrquery-excel-activi...
Solution: https://docs.google.com/spreadsheets/...
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: