Bad Splitting?
Suppose I have this table: CategoryItemLevelA1deltaA2foxtrotA3hotelB1julietB3lima Note that Category=B, Item=2 is missing. If I try to "split" this table with "Split By" = Category and "Split Columns" = Level, and "Keep All", it returns this: ItemAB1deltajuliet2foxtrotlima3hotel Note that on the newly Split table, it shows that Item=2,Category=B is "lima", but that's incorrect -- that c...