In Power Query you can easily split a column into multiple columns. Recently I have had several examples where I needed to split a data set into equal groups of 4 (not bins or frequency). I had to count the total number of rows in the data set. Then insert a blank row evenly between each quarter of the data set. Yes there's probably VBA to do it, but I'd rather have it as part of a PQ solution.