Forum Discussion
Data Management in Excel
I have a business with large amount of information prepared by a staff member - client and prospect names, key personnel within that business, their addresses, their emails, their phone numbers etc e...
I've attached a an Excel File containing a Power Query routine that should help solve your issue
You will need to go into Data > Queries and Connections and then double click on Clean Data in the right hand pane to open up Power Query
Click on the cog next to Source and pick your file name that contains the messy data
Also I've assumed the data is on Sheet1, if not click the cog next to Navigation
Then click on the last step "Removed Columns 1" and you should see your data cleaned up. Then click Close and Load