From the course: Excel Power User Challenge

Unlock this course with a free trial

Join today to access over 24,600 courses taught by industry experts.

Splitting and merging codes using PowerQuery and TEXTJOIN

Splitting and merging codes using PowerQuery and TEXTJOIN - Microsoft Excel Tutorial

From the course: Excel Power User Challenge

Start my 1-month free trial Buy for my team

Splitting and merging codes using PowerQuery and TEXTJOIN

“

- [Instructor] Here's a situation where you're going to need strategy more than anything else. Look at this data. This data came from another source. And in that source, look at the Codes column. There were nice spaces in between each code, now they're all mashed together. Look at this, over in column F, the acceptable codes are E, JH, TE, and V4. We want some kind of delimiter back between the codes. Like in C3, we want V4, a delimiter and then JH. You get to pick the delimiter. Colon, space, two asterisks, 11, backslashes, whatever you want as the delimiter, you get to pick that. But one thing we want to do, identify any records that have any errant codes. Is there anything with a W, or a 19, or an asterisk. We need to get rid of those records. And then with the remaining ones, go ahead and put the delimiters into the sales, right? Got to have a good strategy. All right, pause the video, get that worked out and then…

Contents