Forum Discussion

dipshay17's avatar
dipshay17
Copper Contributor
Oct 16, 2022

How can I split a collumn of numbers into sets of 3

Hi there,   I have a collumn of data (162R x 1C) that I would like to split into 54R x 3C.   I have this x x x y y y z z z   I want to get to this (where each number is in a different ...
excel
Formulas and Functions
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Oct 17, 2022

dipshay17 Based on the file provided by OliverScheurich , you could use the following query as well:

let
    Source = Table.Split (Excel.CurrentWorkbook(){[Name="Tabelle1"]}[Content], 3),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Added Custom" = Table.AddColumn(#"Converted to Table", "Custom", each Table.Transpose([Column1])),
    #"Removed Other Columns" = Table.SelectColumns(#"Added Custom",{"Custom"}),
    #"Expanded Custom" = Table.ExpandTableColumn(#"Removed Other Columns", "Custom", {"Column1", "Column2", "Column3"}, {"Column1", "Column2", "Column3"})
in
    #"Expanded Custom"

 

Resources