It's beginning to look a lot like...Advent of Code! Get in the holiday spirit by learning how you can participate in this friendly competition and earn a seasonal badge.
I've used Data Cleansing tool for new line character removal, but check as well the solution with RegEx tool. Cool one, but need to study more this tool. :)