Unstack Rows in Separate Columns
Ғылым және технология
Check out our newly launched M Language course ↗️ - goodly.co.in/learn-m-powerquery/
Learn how to unstack rows in separate columns using Power Query in Excel
Download the file here - www.goodly.co.in/unstack-rows...
More Tips and Tricks on Power BI - www.goodly.co.in
- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
- - - - Blog - - - -
www.goodly.co.in/blog
Пікірлер: 25
Check out our newly launched M Language course ↗ - goodly.co.in/learn-m-powerquery/
Love it! Very concise and easy to follow. Excellent video!
Great, Thank you!
@GoodlyChandeep
Жыл бұрын
You are welcome!
Hi Chandeep. Awesome trick! Just found this video. Exactly what I needed. Thanks for sharing :)) Thumbs up!!
Amazing shortcut!
Nice...
So neat! Thanks Goodly Chabbra
@GoodlyChandeep
4 жыл бұрын
My pleasure!
Nice Chandeep
@GoodlyChandeep
Жыл бұрын
Thank You!
So cool ...liked it very helpful
@GoodlyChandeep
4 жыл бұрын
Glad it was helpful!
In the opposite , it is possible to insert blank row by subgroup in PQ?
Cool....
Couple days ago at work I was stucked with modulo column cause it didnt want to pivot, so I've just sitting and starring at screen what I've made wrong. :)
Is this applied to multiple column also ?
Good one. Though the post is two years old, attempted to normailse the column data to normal table without using index column. the result is attached and may be helpful to someone // Normalised let Source = Excel.CurrentWorkbook(){[Name="EvnColRecd"]}[Content], #"Filtered Rows" = Table.SelectRows(Source, each ([Column1] null)), SplitRecords = List.Split(#"Filtered Rows"[Column1],FieldCount), #"Converted to Table" = Table.FromList(SplitRecords, Splitter.SplitByNothing(), null, null, ExtraValues.Error), ObtainRecords = Table.AddColumn(#"Converted to Table", "Custom", each Record.FromList([Column1],Header)), #"Removed Columns" = Table.RemoveColumns(ObtainRecords,{"Column1"}), #"Expanded Custom" = Table.ExpandRecordColumn(#"Removed Columns", "Custom", Header) in #"Expanded Custom" // FieldCount 4 meta [IsParameterQuery=true, Type="Number", IsParameterQueryRequired=true] // Header let Source = Excel.CurrentWorkbook(){[Name="Header"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"Header", type text}})[Header] in #"Changed Type" Header is a table in excel with the Names of the fields (Name,City,Age,Phone#)
I like the subtracting columns approach to identify columns, etc. However, what if the list was provided as a PDF / image type of text listing that's in the same format you show. How would one convert that to Excel to accomplish the same type of Excel presentation. Basically, I think this is a "conversion" issue only. Please comment.
@GoodlyChandeep
4 жыл бұрын
Arnold you can use the "Office Lens" app to convert a picture to typed text and then work with that further :)
@rauljimenez5485
4 жыл бұрын
Also, there is an option to import from pdf in ppwer query
@GoodlyChandeep
4 жыл бұрын
@@rauljimenez5485 Yes there is but in Power BI not in Excel Power Query
Could someone please help me? I keep following his instructions exactly for my own documents but I keep getting null and rows are completely off.
@GoodlyChandeep
4 жыл бұрын
Michelle, can you send me a sample of your data and the query that you've created on my email - goodly.wordpress@gmail.com i'll take a look! Thanks
@mchllwoods
4 жыл бұрын
@@GoodlyChandeep the email u sent me didn't work but I tried again one last time. I realize now u jumped to a completely different query in the video. that's what kept messing me up but thx anyway!