Excel Alteryx

[MahanteshS]

Q.1) How to remove empty rows from excel sheet ?

Q.2) How to Rename a column name in an excel file?

[Vijuzy]

Use filter tool to remove empty cells and use select tool to rename
fields...

[mnitin3 · Accepted solution]

So you can follow workflow:

Input file > text to columns tools > select tool(rename field names) > Filter (to remove empty columns) > output.

Please feel free to contact for further questions.