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
- Edited by Tobias Weysters Friday, September 04, 2015 8:05 AM