arranging data using VBA

[monty_mm]

Hello guys,
i'm fairly new to VBA and i need some help with arranging data as follows in Excel:
For example sheet 1 has the following:
Name Colour Price
Toyota White 2000
Nissan Red 4000
Honda Black 1000

i need to have the following in sheet 2:
Toyota White
Toyota 2000
Nissan Red
Nissan 4000
Honda Black
Honda 1000

my thoughts are to do this code in VBA where the code can quickly arrange the data as required. i need this because i have something like 1000 data that i need to arrange so a VBA code will save me tonnes of time!

hope somebody can help.

regards,
Monty_mm

[VBAddIn]

Please See:
http://www.excelforum.com/showthread.php?t=635939
I hope so it help to you!

[monty_mm]

VBAddin,
thanks for your reply, however i am not trying to extract data out, i am trying to arrange it. the data i have are in cells in sheet 1 as follows:

Name Price Model
Toyota Blue 2000 2006
Nissan Red 4000 2007
Honda Black 1000 2008

i need to arrange it into cells as follows in sheet 2.
NAME CODE
TOYOTA BLUE
TOYOTA 2000
TOYOTA 2006
NISSAN RED
NISSAN 4000
NISSAN 2007
HONDA BLACK
HONDA 1000
HONDA 2008

Hope this is clearer.

[VBAddIn]

VBAddin,
thanks for your reply, however i am not trying to extract data out, i am trying to arrange it. the data i have are in cells in sheet 1 as follows:

Name Price Model
Toyota Blue 2000 2006
Nissan Red 4000 2007
Honda Black 1000 2008

i need to arrange it into cells as follows in sheet 2.
NAME CODE
TOYOTA BLUE
TOYOTA 2000
TOYOTA 2006
NISSAN RED
NISSAN 4000
NISSAN 2007

Hope this is clearer.

I think so this work want macro for only you, I write it for you and I send file "Testing" for you.