pivot function help

[Anonymous]

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

[bbi_mba_76]

Hi,

I don't see the attachment.

[#3]

Try to use Cross table...........

[Anonymous]

sorry i missed

[Anonymous]

I know its cross tab function..but requirment is different one