课程: Excel: Power Query?(Get & Transform)

今天就学习课程吧！

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

Split into rows

Split into rows - Microsoft Excel教程

课程: Excel: Power Query?(Get & Transform)

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

Split into rows

“

Let's talk about split a column into rows. Well, this was not part of Power Query when it was originally released. But when this showed up, I don't know if you saw the fireworks, you might not have known what was going on, but that's what this was about. Here we've got the data that says we've got products in column B, whatever the products are, doesn't matter, the colors that are available in each product, and then we've got a ratings column. We need two things from this data. One, a list of all of the colors. Second, account of the colors for each product. The cursor is in the dataset. Right-click, Get Data from Table/Range. First, let's get a list of the colors. I want to highlight the column, right-click, Remove Other Columns. Still highlighted, Split Column, By Delimiter. I don't want to just split by the comma, because I don't want to have to deal with trailing or leading spaces afterwards, so I'm going to split by comma, space at each occurrence of the delimiter. Watch this…

内容