Issue in Unpivot in Power Query

[bourne2000]

Hi

I am having below table

I want to have the output as follow,

Custom	Year	Value
Tower	2018	180051.45
Tower	2019	16603.18

When I tried to use unpivot, I am getting below

Can anyone advise?

[HotChilli · Accepted solution]

Rename the Value columns before the Unpivot.  Rename them to be like ValYear1, ValYear2 , that is, put the number at the end.  This will be used to identify pairs.

OK, so do the unpivot.

Then Split the Attribute column By Non-Digit to Digit.

Then Pivot the Attribute.1 column using Values and "Don't Aggregate".

--

Let me know how it goes