Invalid Column Index and missing null values

wbrooksga12

I'm having two separate issues and I'm unsure of what to do. 

Issue #1: The summarize from my union has nothing in the columns of brand and model even though those fields are in the union. It also says "Name: Invalid Column Index" in the field information. I'm not sure if that's an error or not. 

Issue #2: There are four nulls in the "series" field that I need to replace. I can see they exist in the browse tool coming off my input data but I can't find them later on in my workflow so I can replace them with the correct values. 

I think I have correctly exported the file below. I'll continue working. Any help would be greatly appreciated. 

EDIT: SOLVED TY SO MUCH

HMC Cleaned data_Group12.yxzp

MichalM

@wbrooksga12 

Issue #1

The data is there but lower down - you have Nulls in the both the Brand and Model columns and as a result these will also be treated as values you're grouping on.

If you'd like to disregard these, use a Filter before the Summarize.

Issue #2

These can be found on the False side of your Filter