Bengaluru, IN

Welcome to the Bengaluru User Group

Click in the JOIN GROUP button in Home to follow our news and attend our events!

Excel alteryx

MahanteshS
8 - Asteroid

How to remove empty or null  rows from excel?

3 REPLIES 3
Vijuzy
8 - Asteroid
Use filter tool to remove empty rows or you can also use data cleanse tool to clean the data

Data cleanse tool- https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-Data-Cleansing/ta-p/31753

Filter tool- https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-Filter/ta-p/85764
cypherboy
5 - Atom
rm.na=TRUE


AAKASH
MahanteshS
8 - Asteroid
What you mean by "rn.na" in above formula ?