Its almost clear as to what you want. I good way of explaining is to include a desired result in your sample sheet. However if I understand right you want to "Concatenate" all of the values in each column into a single cell. The only thing not quite clear is how do you want each value separated. My assumption would be for row 3 with a cross section of 1 would result in 1.25;1.50;1.75;2.00

Is this correct and if so are you against it being a VBA script.