Hello friends,
I had searched a lot, maybe the terms i used aren't right, i am unable to find any such similar problems and its solution
I have a table of data as given below
I want to convert this to
Requesting seniors and experts to help how to do it in excel maybe through functions or macro or whichever.
My raw data is huge, and i need to find a time saving way to do it.
Regards
kalaate
I had searched a lot, maybe the terms i used aren't right, i am unable to find any such similar problems and its solution
I have a table of data as given below
RAW DATA | |||||
Customer | 010B50 | 010B52 | MNP012 | NGL011 | MGL012 |
3GEN POLY | 10 | 20 | 10 | ||
BDP POLY | 5 | 5 | 10 | 15 | |
ADDY MOULD | 10 | ||||
MN PLASTIQUE | 10 | 20 |
I want to convert this to
DESIRED DATA | ||
Customer | Product | Qty |
3GEN POLY | 010B50 | 10 |
MNP012 | 20 | |
MGL012 | 10 | |
BDP POLY | 010B50 | 5 |
010B52 | 5 | |
MNP012 | 10 | |
MGL012 | 15 | |
ADDY MOULD | NGL011 | 10 |
MN PLASTIQUE | 010B50 | 10 |
010B52 | 20 |
Requesting seniors and experts to help how to do it in excel maybe through functions or macro or whichever.
My raw data is huge, and i need to find a time saving way to do it.
Regards
kalaate