Starting with a table like this:
<tbody>
</tbody>
The desired result is:
<tbody>
</tbody>
I've unpivoted, outer joined, added index columns, replaced values and found several messy ways to get a result. The problems are with:
- Someone who doesn't have an x will disappear. Like Olivia in my example.
- Adding a new City column doesn't show up with "refresh"
Any help is greatly appreciated!
NAME | Illinois | Toronto | Moscow | Belize |
Sarah | x | |||
Roberto | x | x | x | |
Karen | x | x | ||
Olivia | ||||
Todd | x | x |
<tbody>
</tbody>
The desired result is:
NAME | Illinois | Toronto | Moscow | Belize |
Sarah | Illinois | |||
Roberto | Toronto | Moscow | Belize | |
Karen | Illinois | Moscow | ||
Olivia | ||||
Todd | Moscow | Belize |
<tbody>
</tbody>
I've unpivoted, outer joined, added index columns, replaced values and found several messy ways to get a result. The problems are with:
- Someone who doesn't have an x will disappear. Like Olivia in my example.
- Adding a new City column doesn't show up with "refresh"
Any help is greatly appreciated!