Alternating data in Power Query.pbix

Goal

Alternating data in Power Query

Solution

1. Add a new [Index] column

https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1010561iA2357F06B4E23D6E/image-dimensions/492x196?v=v2

2. Create new conditional columns based on [Index]

https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1010563i565FE17ED4BF1C4D/image-dimensions/490x106?v=v2

3. Remove incorrect columns and [Index]