# Tags **Software** : [[02 - Tags/Software/Power Query]] **Functions** used : [[Excel.CurrentWorkbook]] [[Table.TransformColumnTypes]] [[Table.AddIndexColumn]] [[Table.AddColumn]] [[Table.FillUp]] [[Table.SelectRows]] [[Table.Group]] [[List.Transform]] [[Table.FromRows]] [[Table.Combine]] [[Table.RenameColumns]] [[Table.ToRows]] **Date** : 21-March-2025 # Description # Video Link <iframe width="560" height="315" src="https://www.youtube.com/embed/JTKW7f62eb0?si=zK1sgW-XpdtTlTrl" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" referrerpolicy="strict-origin-when-cross-origin" allowfullscreen></iframe> [GITHUB File Link](https://github.com/jbotes/powerbiTutorials/blob/main/PQ_Unstack_Data_Uneven_Video.xlsx) # M-Query ```mquery let Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"RateData", type any}}), #"Added Index" = Table.AddIndexColumn(#"Changed Type", "Index", 1, 1, Int64.Type), #"Added Custom" = Table.AddColumn(#"Added Index", "Custom", each if [RateData] = null then [Index] else null), Custom1 = Table.FillUp(#"Added Custom", {"Custom"}), #"Filtered Rows" = Table.SelectRows(Custom1, each [RateData] <> null and [RateData] <> ""), #"Grouped Rows" = Table.Group(#"Filtered Rows", {"Custom"}, {{"data", each _[RateData]}}), Custom2 = List.Transform(#"Grouped Rows"[data], each Table.FromRows({_})), Custom3 = Table.Combine(Custom2), #"Changed Type1" = Table.TransformColumnTypes(Custom3,{{"Column2", type date}}), #"Renamed Columns" = Table.RenameColumns(#"Changed Type1",RenamedColumns) in #"Renamed Columns" ``` ```mquery let Source = Excel.CurrentWorkbook(){[Name="Table4"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"Default", type text}, {"Rename", type text}}), Custom1 = Table.ToRows(#"Changed Type") in Custom1 ``` ## Optional Tags **Tags** : **Technique** :