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
Lorenzo's avatar
Lorenzo
Silver Contributor
Oct 17, 2022

Hi dipshay17 

 

Another Power Query option based on OliverScheurich sample:

let
    Source = Table.Split(Excel.CurrentWorkbook(){[Name="Tabelle1"]}[Content], 3),
    Transposed = List.Transform(Source, Table.Transpose),
    Combined = Table.Combine(Transposed)
in
    Combined

Resources