Taking Cell Content to Seperate Columns

[ryanb4614]

Hello. I had a code that would take cell content and put it into separate columns. Since then my computer crashed and I cannot find the code I had. It was ran through Macro. Hoping someone can help duplicate the code of its function. Please see the attached file for what I am working with
Each of these were in separate column. There is a lot of content in each cell. The original code would add numbers in orderto each Make/Model/Sub Model/ Ending Year/ Beginning Year/
Make1 Model1 Submodel1 etc and keep counting.

Bumper Location (application):Front

Universal:No

Make:JEEP

Model:CJ5

Submodel:BASE

Beginning Year:1976

Ending Year:1988

[Bernie Deitrick]

This seems to work....

Please Login or Register  to view this content.

[ryanb4614]

Thank you for the reply. I need it to remain in the same row. So I would need multiple columns (multple columns) not multiple rows....for example
Row 1: Bumper Location (application) Universal Make Model Submodel Beginning Year Ending Year Application Notes Bumper Location (application) Universal Make Model Submodel Beginning Year Ending Year Application Notes

So with the example in my previous post after head space I need that to be a new column Make=Chevy Make under it Chevy and repeat making new columns now rows.

The may be other content from column a to f that needs to remain there as well.

[Bernie Deitrick]

Well, your example workbook left a lot to the imagination and spreading your data out along a row and duplicating columns violates all 'good data' rules. Anyway, try this version

Please Login or Register  to view this content.

[ryanb4614]

I understand this is a done of data. This is what ebay requires for product uploads. Its a pain and I am just trying to figure it out. What you have supplied works great. Is there a way for this macro not to delete the other columns before application1...it can remove application1 and application2

[Bernie Deitrick]

Not sure what you mean - try removing this line from the macro to keep the original data:

Please Login or Register  to view this content.

Note that the autofit will make the columns with the original data really wide, so you may want to remove that line as well.