课程: Excel: Tracking Data Easily and Efficiently

今天就学习课程吧！

今天就开通帐号，24,600 门业界名师课程任您挑！

Splitting columns

Splitting columns - Microsoft Excel教程

课程: Excel: Tracking Data Easily and Efficiently

开始一个月试用 购买团队方案

Splitting columns

“

- [Instructor] Now I'm going to take you into some Power Query. But first, let me tell you, sometimes when I mention Power Query it's thought of as advanced. I don't think advanced, I think of common needs that people need help with and so many people have to deal with splitting columns apart. Here is our data. This source has come to us and we can't use it. We've got last name, comma, first name, then a semicolon, and then vocals for Danna Alvarez. And look down at Diego G. Murphey. Three instruments, keys, comma, space, flute, comma, space, sax. What we want is a first name column, a last name column, and then a column for the instruments. And we only want the people who have vocals or bass as one of their instruments. So Latricia Davis, guitar. No, we don't want Latricia in our final data set. Jean Matsuno. Yes. Jean has both bass and vocals. So, let's get started. Now, there is text to columns in regular…

内容