Merge top two cells of a column in Power Query

[Anonymous]

Hi there

I have to work with this god-awful excel file from Finance where they have displayed the data in a very non-friendly format for Power BI.

It looks like the attached photo. So the top two rows are year and month and I want to combine them. Is this possible? 

[CNENFRNL · Accepted solution]

of coz, some easy steps,

transpose - combine the leftmost 2 columns - transpose

[v-xiaotang]

Hi @Anonymous 

Have you solved this problem? If yes, could you kindly accept the answer helpful as the solution (or kindly share your solution ). so the others can find it more quickly.
really appreciate!
Any question, please let me know. Looking forward to receiving your reply.

Best Regards,
Community Support Team _Tang

[v-xiaotang · Accepted solution]

Hi @Anonymous 

Have you solved this problem? If yes, could you kindly accept the answer helpful as the solution (or kindly share your solution ). so the others can find it more quickly.
-

if not, you can use transpose in PQ then combine the 2 columns (you cannot combine rows into one row in PQ), or combine the first two rows in Excel directly, e.g. =C110&" "&C111.

in PQ, for example,

result

Any question, please let me know. Looking forward to receiving your reply.

Best Regards,

Community Support Team _Tang

[CNENFRNL · Accepted solution]

of coz, some easy steps,

transpose - combine the leftmost 2 columns - transpose