Hi,
I have a file containing company address details. The first column in the file denotes the company name, the second column the address field name, and the third column shows the actual address. There are 5 address fields for each company.
I want to change the data layout so that there is one row for each company and the address fields become columns. I tried pivoting the data in power query but it just returns a value of 1 for the address entries.
I have attached a file showing the current layout and the output I need.
Thanks
Bax
Hi Bax,
You can pivot the Address Field column with the Details column containing the 'Value'. In the Advanced options choose 'don't aggregate'.
Mynda
Hi Mynda,
I knew there had to be a simple solution. I didn't get as far as looking at the advanced options. Your solution works perfectly.
Thanks for your input. Invaluable as always.
Bax