OK, so I'm not sure this is even truly a bug, more just an annoying corner case. The problem is: when pivoting on multiple columns, the new column names are made from joining the pivot values with '_' ...