Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have excel sheet I have date and name row should be act as column.. i need the below output pls find attachment
sl no | RPO NUMBER | customer | Equipment | delivery date | remarks | Date | Name | Hour |
1 | RPO 13-14-156 | Dream plast | sprue picker | waiting for material | 27/12/2013 | Ram | 4 | |
2 | RPO 13-14-173 | Dream plast | conveying | TO BE STARTED | 27/12/2013 | Ram | 3 | |
3 | RPO 13-14-174 | Dream plast | conveying | TO BE STARTED | 27/12/2013 | Ram | 2 | |
4 | RPO-13-14-167 | poly plastics | mtc 140 | Ready for dispatch | progress | |||
5 | RPO 13-14-164 | poly plastics | chiller 2 tr | waiting for material | waiting for material | |||
6 | RPO 13-14-170,171,172 | poly plastics | conveying | PROGRESS | ||||
7 | RPO-13-14-177 | ijl | eoat assy | to be started | ||||
8 | RPO 13-14-162 | Kalyx plasti | WFR 10zone | week 52 reaching at chennai | waiting for material | |||
9 | RPO-13-14-146 | visteon automotive | conveying accessories | waiting for ETA | waiting for material | |||
13 | NA | in house | 50 ltr HAD | waiting for CONTROL BOX | waiting for material | |||
14 | NA | in house | 100 ltr HAD | waiting for CONTROL BOX | waiting for material | 27/12/2013 | mur | 5 |
15 | RPO-13-14-157 | Mahle filter systems | Granulator | waiting for ETA | waiting for material | |||
16 | RPO-13-14-147 | PIOLEX | CONVEYOR | waiting for ETA | waiting for material | 27/12/2013 | mur | 3 |
17 | RPO-13-14-176 | PIOLEX | CONVEYOR | waiting for ETA | waiting for material | |||
18 | RETURNED | SL LUMAX | eoat assy | |||||
19 | REWORK | VALEO | eoat assy | 27/12/2013 | sam | 8 |
RPO NU
Hi,
I don't see the attachment.
Try to use Cross table...........
sorry i missed
I know its cross tab function..but requirment is different one