Data extraction

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jimmy Joseph - 07 Jul 2006 10:12 GMT

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

Reply to this Message

Paul Lautman - 07 Jul 2006 10:48 GMT

> Hello,
>
[quoted text clipped - 23 lines]
>
> 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.

Reply to this Message