Merge rows in a straight table

[AlexO84]

Hi all,

I have the following table:

The first 2 rows are taken from the DB (Safety stock in each site), the 3rd row is calculated sum (of the 2 different sites).

I'm trying to group similar P/N's in one row (instead of 3), so it would look like this:

Any ideas?

Thanks, 

Alex.

[vinieme12]

temp:

LOAD * Inline [
Dim1,Dim2,Value,String
B,,,,
B,A,10,
B,A,,wefwef
];
NoConcatenate
Main:
Load
Dim1
,MAXSTRING( Dim2) AS Dim2
,mAX(Value) as Value
,MAXSTRING(String) as String
Resident temp
Group by Dim1;
Drop table temp;

[AlexO84]

Can you please elaborate..?