headers

[Anonymous]

Hello

i start to apologize if this issue has already been raised, i did a few searches but didn't find.

My problem is simple : i've got an excel file to import, and my headers would be the concatenation of values in row1 & row2.

PowerQuery let me promote the first row (or the 2nd one) but i want both of them 🙂

	Q1 FY16	Q1 FY16
	Arrêté T	Arrêté T N-1
PRODUIT NET BANCAIRE	76,667	,
PNB Hors EL	77,541	,
Marge nette d'intérêts	45,205	,
MNI Hors EL	46,079	,

I need these headers :

Q1 FY16 Arrêté T   |   Q1 FY16 Arrêté T N-1

Thanks for your help !

Stephane

[Anonymous · Accepted solution]

In Power Query > Transform Tab, transpose the table.

Create a new column that merges/concatenates the two rows (that are now columns).

Pull the new column to the beginning of the table.

Transpose the table again.

Promote the new merged row to header.

[Anonymous]

oh i've seen this yesterday but i did unpivot instead of transpose, that's why i failed

thanks for your help

[Anonymous]

works great