Data Cleaning

Hi everyone,

Could you please provide me steps to clean data in the file attached?

• Seperate data to different row if there are symbol ',': For example, "AA1, BB1, CC1" is in cell A2. I need the "AA1" in cell A2, while "BB1" in the cell A3 and etc.
  
• Remove cell (shift up) if there is no number in the cell: For example, "AA" in the cell A4 should be excluded from the list because it doesn't contain number.

Please take a look at the file attached for my expected output with samples.

Thank you and have a nice day