Help with layout change

G

gaotar

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 hel
would be greatly greatly appreciated!!!
Thank you all!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is this an Index/Match formula? 5
Need help creating macros 6
Macro / VBA Help 2
conditional formatting color 6
Question about using MIN/MAX, INDEX with Date range 3
Sum with multiple conditions 6
Formula that uses column 7 row titles - DIFFICULT!! 3
Database Reference Formula Help 0

Top