Merged cells are the enemy of data merging. Convert them to "Center Across Selection" before starting.
Power Query will: