Separating multiple data (w delimiter) from one cell to many cells

Hi Sixthsense,

Please see the sample workbook attached in this post.

Additional information you may need:

• I need the "Account #" column to be entered separately per row. Each account # for each row.

• All other columns for a specific account # should also be included.

• The comma (,) delimiter should be removed and the quote-sign (" ")

Thank you