moving cell contents

I need to have the data from a text file rearranged to show each product in one row.

I attached the original file and changed the first 2 lines to show what is wanted.

Hi Mikeyd1
Looking at your file, it appears that each item has either 7 or 6 rows of data associated with the item. Will this ALWAYS be true?

Hello Mikeyd1,

Welcome tot he Forum!

The macro below will convert the data from horizontal to vertical. The converted text is copied over to a second sheet named "Results". The macro was written to start at cell "A13". Your actual file probably starts at a different cell. Change the starting cell marked in bold in the macro below before running this on the real file. Also, be sure to add another worksheet and name it "Results" in your workbook with the original text. There is button on the "Results" worksheet to run the macro.

Please Login or Register  to view this content.