
Live QA Meeting for Elevate – August 2023
Get your Excel-related questions answered during our monthly live Q&A meeting.
Download Example Files
Get your Excel-related questions answered during our monthly live Q&A meeting.
Download Example Files
You must be logged in to post a comment.
Please confirm you want to block this member.
You will no longer be able to:
Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.
Using Power Query I first made a duplicate Category Item column and then was able to use ‘Replace Values” to remove the extra spaces (i.e.; Electric Bikes Super Commuter+) to make the Category Item (i.e.; ElectricBikes Super Commuter+). Then I was able to split the columns by the left space delimiter. Finally, I could use ‘Replace Values’ to add the space back in for the new Category column. Close & Load and the data was perfect!
Very nice, Steve! 🙂 Way to take on Power Query! 👍