Renaming Cells or Column Headers in a loop with Power Query

Hey there,

I am using Power Query for process some of my access logs for several countries.

Currently, the first row is showing several country abbreviations each seperated by an empty cell (For Example "US" "null" "UK" "null" "DE" etc.). The row beneath repeats the two values "Internal" and "External" all the time.

What I need to do is to change the second row to combine both rows ("US_Internal", "US_External", "UK_Internal", "UK_External" and so on).

There is no problem in doing this manually, but as there are about 100 countries, I wanna do this automatically. Another Problem is, that the amount of countries changes as only countries with at least on access are listed!

Can anyone help me out?

Thanks a lot!

Toby


September 4th, 2015 7:27am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics