Power Query. Combine the first two rows. RRS feed

  • Question

  • 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 an article called "Absolute & Relative References" but can't currently find information about relative column references.


    1. Transpose table

    2. Merge two first columns

    3. Transpose again

    • Edited by OttoErago Tuesday, March 28, 2017 4:46 PM Solved
    Tuesday, March 28, 2017 4:34 PM


All replies

  • I also found the same solution on Stackoverflow.
    Tuesday, March 28, 2017 5:05 PM
  • Hi @MarcelBeug,

    This may not always work as there is a limitation to the number of rows you can TRANSPOSE to columns. Power Query cannot handle more than 16,384 columns. So, if you have a table with more than 16,384 rows, transposing that table will lead to Errors.

    Regards. ~~SiFaR~~

    Sunday, September 29, 2019 3:47 PM