Consolidate Data_12122023.pbix

Goal

Consolidate the data in Power Query editor

Untitled

Solution

  1. Add a [Index] column to your table

  2. duplicate the orginal table

distinguish the two table by [Index], for example, the first one with [Index] less than 4 and the second one greater than 4

  1. Remove blank column in the first table and rename columns in the second table

  2. Append queries, so you'll have a consolidated clean table.