Hi again xld,

thank you for your reply!

I have unpivoted my columns using PowerQuery and I now have 3 columns, city name, metric and value.

How should I proceed?