Search code examples
powerbipowerquerym

Power Query. Combine the first two rows


I have a spreadsheet with Year in row 1, and Month in row 2.

I need to combine them into dates before promoting the resulting row into a header row.

The data looks like this:

2017, 2017, 2017,...
Jan , Feb,  Mar ,...

I'm trying to get:

Jan 2017, Feb 2017, Mar 2017,...

I've read this but can't find information about relative column references Absolute & Relative References.


Solution

    1. Transpose table

    2. Merge first two columns

    3. Transpose again

    Link