Automatically clean-up excel data with multiple entries per cell separated by comma or line-breaks

This is a follow-up from a previous post where I did the same using PowerShell. A short recap first. The goal is to turn something like this: Into this: In the original state some of the cells have multiple entries that are either separated by comma or line-breaks (via Alt+Enter). Furthermore several of those entries […]

Using PowerShell to clean-up excel data with multiple entries per cell

How many times did you come across a situation where you were supposed to work with Data that looks like this?: Some of the cells have multiple entries that are either separated by comma or line-breaks (via Alt+Enter). Furthermore several of those entries contain extraneous spaces. Happy days! What would be actually needed in order […]