LOOKUP
 

Hi, I need help in finding out the result from Sheet 2 consist of 4 col.

Group Catagory Item Balance

Watch Qatz H0001 1000
Watch Qatz H0002 1000
Watch Digital H0003 1000
Watch Digitsl H0004 1000
Toy Electro T0001 50
Toy Electro T0002 50
Toy Mech T003 50

I need result as:
Watch
Qatz
H0001 1000
H0002 1000
Digit
H0003 1000
H0004 1000
Toy
Electro
T0001 50
T0002 50
mech
T0003 50

Thank you for your help.
Kannan.

LOOKUP
 

Time to delve into pivot tables

http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm
http://www.techonthenet.com/excel/pivottbls/index.htm
http://www.dicks-blog.com/archives/2...le-parameters/
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Krish" wrote in message
...
Hi, I need help in finding out the result from Sheet 2 consist of 4 col.

Group Catagory Item Balance

Watch Qatz H0001 1000
Watch Qatz H0002 1000
Watch Digital H0003 1000
Watch Digitsl H0004 1000
Toy Electro T0001 50
Toy Electro T0002 50
Toy Mech T003 50

I need result as:
Watch
Qatz
H0001 1000
H0002 1000
Digit
H0003 1000
H0004 1000
Toy
Electro
T0001 50
T0002 50
mech
T0003 50

Thank you for your help.
Kannan.