# Tags **Software** : [[02 - Tags/Software/Power Query]] **Functions** used : [[Excel.CurrentWorkbook]] [[List.Split]] [[List.Transform]] [[Record.FromList]] [[Table.FromRecords]] [[Table.TransformColumnTypes]] **Date** : 21-March-2025 # Description - in this video i show you how to easily unstack row datasets into columns. # Video Link <iframe width="560" height="315" src="https://www.youtube.com/embed/WnzQU-T3ZB0?si=ETHC_gTJTCOdYsyt" 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.xlsx) # M-Query ```mquery let Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content], Custom1 = List.Split(Source[RateData], 4), Custom2 = List.Transform(Custom1, each Record.FromList(_, {"Country", "BankRate", "Change","Date"})), Custom3 = Table.FromRecords(Custom2), #"Changed Type" = Table.TransformColumnTypes(Custom3,{{"Date", type date}}) in #"Changed Type" ``` ## Optional Tags **Tags** : **Technique** :