This may work if...

Your data in column A is always duplicated (exactly two rows per company) and
the data is always in 3 columns (only B:D).

If the data starts in row 1, put this in E1:
=IF(MOD(ROW(),2)=1,B2,NA())
Drag it across E1:G1

Drag E1:G1 down as far as your data goes.

Now select E:G
Edit|copy
Edit|paste special Values

With E:G still selected:
Edit|Goto|Special|Constants
and uncheck Numbers, text, logicals, but leave Errors checked (hit ok)
Now all the #N/A's are selected
edit|delete|Entire row.



whicks wrote:
>
> 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.

--

Dave Peterson