Help with layout change
 

Hello,

Could anybody help with layout functions in excel?

I have following layout

ColumnA ColumnB ColumnC ColumnD ColumnE
Toyota red blue grey
Honda blue pink grey
Mazda red pink

And I need:

ColumnA ColumnB
Toyota red
Toyota blue
Toyota grey
Honda blue
Honda pink
Honda grey
Mazda red

Can anybody help?? My table is a huge one with 6000 lines and your help
would be greatly greatly appreciated!!!
Thank you all!!!


--
gaotar
------------------------------------------------------------------------
gaotar's Profile: http://www.excelforum.com/member.php...o&userid=35835
View this thread: http://www.excelforum.com/showthread...hreadid=556189