How to split a column in Excel Power Pivot 2013?

I'm studying reports with Power view and Power Query, and I need to split the content of a column

For that I'm seeking the QUERY tab and the Edit button as below, but I don't find them. 

What did I miss ?

Thanks

June 9th, 2015 3:39am

Hi WLID,

Based on your image and your description, you wonder to split a column in Power Query. But your case title is wonder to know how to split a column in Power Pivot, did you write the wrong title?

For split a column in Power Pivot. In Excel go to Data > Text to columns > Delimited > Space > Finish.  Then take the data to PowerPivot.

For split a column in Power Query.  Using the Query Editor in Power Query, a column of text can be split into multiple columns in two ways: by delimiter or by a number of characters.

By Delimiter parses a text value based on a common character into two or more columns. For example, a Name column as LastName, FirstName can be split into two columns based on the comma (,) character.

By Number of Characters parses a text value based on a character position within a text value.

Please refer to this article to get the methods about how to split a column in Power Query.

https://support.office.com/en-in/article/Split-a-column-of-text-Power-Query-5282d425-6dd0-46ca-95bf-8e0da9539662?ui=en-US&rs=en-IN&ad=IN

Hope its helpful.

Regards,

George Zhao
TechNet Community Support

Free Windows Admin Tool Kit Click here and download it now
June 10th, 2015 2:51am

Thanks a lot George,

Definitely, I wrote the wrong title...

June 10th, 2015 3:06am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics