Alternating data in Power Query.pbix

Goal

Alternating data in Power Query

Solution

  1. Add a new [Index] column

  1. Create new conditional columns based on [Index]

  1. Remove incorrect columns and [Index]

Untitled