Do not change name of column names while transpose

[piotr_gor]

I stuck on trying to pivot/transpose data from view like this: 

Name of column	Value
Nr	5556476
Name	Contoso
Country	Italy
Nr	9652142
Name	Microsoft
Country	USA
Nr	66982314
Name	Tesco
Country	UK

To this: 

Nr	Name	Country
5556476	Contoso	Italy
9652142	Microsoft	USA
66982314	Tesco	UK

How do I do that in power pivot. Tried transpose but it changes repetetive value from "Name of column" by adding number at the end of name of column. 

I'm pretty sure it's not that difficult but can't do you without you help. 

[Idrissshatila · Accepted solution]

Hello @piotr_gor ,

It automatically change the name, but you can rename the column name as you like.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin