I could sure use some advise.
I have a spreadsheet with information displayed like this:

Column A B C D

company 1 red 200 pencil
company 1 blue 50 pen
company 2 purple 300 marker
company 2 orange 50 peanuts
company 3 Holy Cow Woohoo
company 3 Eye Am Confused

I need to transpose it to look like:

Column A B C D E F G

Company 1 red 200 pencil blue 50 pen
Company 2 purple 300 marker orange 50 peanuts
etc.

I can build my own basic functions and a beginner at VBA Code so if you
have any suggestions...Be gentle.