you can either do it manually by copying the data you want, contingent its sequently rows, and paste special and transpose the data, which will copy it across into columns or you have to write code to parse for every 3 pieces of data write into each column and then go to next row. I can write the code if you want, depends on how much you have, might just be easier to manually copy and paste special.