Pivoting table showing up may rows with null values

[Sagejah9]

Hi. I pivoted a table where I need the attributes as column headers and the values as rows, however I am getting rows with null values. How can I clean this up? Is there a another step to do this?

[amitchandak]

@Sagejah9 , if row is null, remove empty rows option in the home tab.

Or right click on column or click on column header -> remove blank/ null values

[Sagejah9]

Hi @amitchandak , Thanks I tried that but it removed rows that have values under other columns so that may not work. 

What it looks like when I pivot

[Icey]

Hi @Sagejah9 ,

How does the data look like before you pivot it?

Best Regards,

Icey

[Icey]

Hi @Sagejah9 ,

How does the data look like before you pivot it?

Best Regards,

Icey