Data extraction

[Jimmy Joseph]

Hello,

I have a data base as below giving datewise requirement of parts

Part 01.07.06 02.07.06 03.07.06

A 50 50
B 70 10
D 50 70
E 5
F 10 5

I would like to have the data in the following format

Date Part Requirement

01.07.06 A 50
02.07.06 B 70
02.07.06 D 50
02.07.06 E 5
02.07.06 F 10

How do I do it using formulas?

Regards,

Jimmy Joseph

 

[Paul Lautman]

Hello,

I have a data base as below giving datewise requirement of parts

Part 01.07.06 02.07.06 03.07.06

A 50 50
B 70 10
D 50 70
E 5
F 10 5

I would like to have the data in the following format

Date Part Requirement

01.07.06 A 50
02.07.06 B 70
02.07.06 D 50
02.07.06 E 5
02.07.06 F 10

How do I do it using formulas?

Regards,

Jimmy Joseph

You need to follow the instructions at
http://j-walk.com/ss/excel/usertips/tip068.htm

then use Autofilter to remove the rows with no quantities listed.