Create header with the 2 first row?

[vbourbeau]

Hi,

I start with a excel calandar as source, in the calandar the first row are the month and year and the second row are the day. Also when I import it the month and year are only in the first column., don't relpicate on other one look the the image below 

The result I'm looking for is :

Also after Janvier (january) it's February:

[vbourbeau · Accepted solution]

ok I've got it

We need to use the Transpose function, soon the column are row I can yous the Fil function and create a column with the merge of two.

Thank