Removing Nulls and renaming the columns with the values from rows

[sriniprad08]

Hi Team,

Hope you are well. I need help. I have attached the input and desired output.

I need to rename the columns by picking the names from the rows and remove any rows with all Nulls.

Please let me know how to go about it,

thanks,

Sri

[Luke_C · Accepted solution]

Hi @sriniprad08 

Here's an example of how:

On input: Start at row 3 to get the right column headers. Then filter out any values in total users that are not integers.

[sriniprad08]

Thank you @Luke_C  . Very helpful. 

Cheers