Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Power Query: Split Multiple Columns into Rows All At Once. That video is uploaded by Excel On Fire at 2020-04-28T18:26:56-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [JMOnr3DOqyk]
| Name | Power Query: Split Multiple Columns into Rows All At Once |
| Video Uploader | Video From Excel On Fire |
| Upload Date | This Video Uploaded At 29-04-2020 01:26:56 |
| Video Discription | It's easy to split columns in Power Query and split into rows. But here's a situation where there's data in 3 columns that will fly apart and get unmatched if we split one column without splitting the other 2 at the same time. One solution would be to split the source data into 3 pieces, split the columns into rows, add index columns, then use outer joins to piece the data back together. We're not going to do that today!We're going to use Power Query's lists, and 2 functions: Text.Split Table.FromColumns These are going to make for a smooth solution! #SplitMultipleColumns #PowerQuery #Text.Split For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course: https://www.linkedin.com/learning/instructors/oz-du-soleil?trk=insiders_28299411_learning Website: http://ozdusoleil.com My book: Guerrilla Data Analysis 2nd Edition http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336 My old blog: http://datascopic.net/blog-2-2 JMOnr3DOqyk |
| Category | Education |
| Tags | Text.Split | table.fromcolumns | Split columns into rows | split multiple columns power query | Fill Down in Power Query | Oz du Soleil | Excel on Fire | Power BI split multiple columns into rows | Power Query split column by delimiter |
