List Formatter & Data Cleaner

Input List:

Output: