# Tags **Software** : [[02 - Tags/Software/Power Query]] **Functions** used : [[Excel.CurrentWorkbook]] [[Table.TransformColumnTypes]] [[Table.Group]] [[Table.ExpandTableColumn]] [[Table.RemoveColumns]] [[sharptable]] **Date** : 30-March-2025 # Description In This video i show you how to add a blank row after each grouping in a dataset using the [#table](https://www.youtube.com/hashtag/table) function. ss # Video Link <iframe width="560" height="315" src="https://www.youtube.com/embed/ZOiQICR7dRM?si=p_8WuE56uZe2or3I" 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_BlankRow_video.xlsx) # M-Query ```mquery let Source = Excel.CurrentWorkbook(){[Name="Table_Valueinvestors"]}[Content], #"Changed Type" = Table.TransformColumnTypes(Source,{{"PortfolioName", type text}, {"Stock", type text}, {"Shares", Int64.Type}, {"Value", Int64.Type}}), #"Grouped Rows" = Table.Group(#"Changed Type", {"PortfolioName"}, {{"Count", each _ & #table({},{{}})}}), #"Expanded Count" = Table.ExpandTableColumn(#"Grouped Rows", "Count", {"PortfolioName", "Stock", "Shares", "Value"}, {"PortfolioName.1", "Stock", "Shares", "Value"}), #"Removed Columns" = Table.RemoveColumns(#"Expanded Count",{"PortfolioName"}) in #"Removed Columns" ``` ## Optional Tags **Tags** : **Technique** :