move data from vertial to horizontal

How do you move data from vertial to horizontal into 2 columns. The parts list is attached. Line 9 and 10 is what I am trying to do with the entire sheet. Is there a formula I can use to do this rather than cut and paste every line?

Hi

This is based on what I think your raw data looks like. It currently outputs the data into column C. I've commented out the part of the code that would delete columns A and B so if it is working correctly, then you can enable that part of the code. Up to you want you want to do with the resulting blank rows....

Please Login or Register  to view this content.

rylo

Thank you! Unfortunately I am a dummy. This is greek to me. Can you look at the parts list and spell it out for me in dummy terms? Sorry to be such a pain. I appreciate any help you can give. I deleted the dupes but am unclear of how to move the data. Jamie

Hi

In the attached file, sheet1 is what I think your data looks like, sheet2 is your original format, and sheet3 is a copy of sheet1. Select sheet1, and run the code. See how it goes.

rylo