How to Merge Multiple Row into One Row for Calculation

[brijeshvma]

Hi

I want to merge multiple row into one Row.. I Have Column

Lot	Barcode	Process	Weight	SID	CID	CLAID	FID	CUID	PLID	SYID	AMT
AB1	AB1-0006	1 Prediction	0.32	BR	E	VVS2	NON	EX	EX	EX	45.14
AB1	AB1-0006	2 prediction	0.31	BR	E	VVS1	NON	EX	EX	EX	48.36
AB1	AB1-0006	5 prediction	0.31	BR	E	VVS1	NON	EX	EX	EX	48.36
AB1	AB1-0006	Self	0.31	BR	D	VVS1	NON	EX	EX	EX	54.03
AB1	AB1-0006	Cert	0.310	BR	D	VVS1	NON	EX	EX	EX	66.79

So i want  whenever Barcode having multiple Process it Show it same row .. Because SID CID CLAID, FID, PLID, Having a Numeric Fix Value...

So i can compare say in Barcode AB1-0006 in Process (5 Prediction ) Confirm E CID but when Self check Done it show D CID ..

so it mean CID Variance 1 in Prediction 5 and Self ..... same way i can Compare any Process to any Process . and i can have Variance

Differece Column as well..

Kindly Check my Attach Data and Master table ...

[sinanozdemir]

Hi,

What is the expected output? Can you provide a sample output table?

Thanks

[brijeshvma]

Hi,

I want the Same Barcode Figure should be same Line .. so i can do Minus is that value ..

[jagan]

HI,

What is your expected output?  can you attach your expected results.

Regards,

jagan.

[zain16nib]

Dear,

generic LOAD CAN HELP TO GET YOUR RESULT,

see example in attachment.

Regards,

Zain.

[sinanozdemir]

Can you please post a sample output? It is difficult to visualize what you are trying to accomplish.

Thanks