Here the data is all in one cell. You can't really work with this data. You need to segregate this data into its separate elements. It looks like there are some numbers, a region, a last name, a product, a quantity, a price and a total.
To solve this problem, we use the cool Text to Columns feature in Excel. The good news is that it's easy to use. The bad news is that most of the time you need to tweak it just a little to complete the transformation.
Here, I created a quick video on how to do just that. Oh and the sample data is here
No comments:
Post a Comment