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!!!