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