How to delete Blank/Empty rows in an Excel

@Lahiru.Fernando Do you have any help for this Split columns into its own rows (comma separated in excel) or how to approach?