Table "summary"

[sabsx]

hi!

Currently I have another problem... I want to summarize all products of an offer in one table row... at the moment I get several rows the same offer number...

example:

the original data look like this:
<table cellpadding="5" cellspacing="5" border="1">
<tr><td>offer nr</td><td>item nr</td><td>item</td> </tr>
<tr><td>1</td><td>1</td><td>flowers</td> </tr>
<tr><td>1</td><td>2</td><td>vegetables</td> </tr>
<tr><td>2</td><td>1</td><td>chocolate</td> </tr>
</table>

and I want to have a table or a pivot table like this:
<table cellpadding="5" cellspacing="5" border="1">
<tr>
<td>offer nr</td><td>items</td> </tr>
<tr><td>1</td><td>flowers, vegetables</td> </tr>
<tr><td>2</td><td>chocolate</td> </tr>
</table>

how can this be made?

all the best,

sabsx

 

[sabsx]

thanks... works...

I have a similar problem with another file...

Mappe2
	A	B	C	D	E	F	G	H	I	J	K
1	V	AngNr	Prod	K2	Typ	Proj	AngWert	Prob	net	Aw	Del
2	TAS/ME	20780001	MG	OVIT-HU	VCG00	HU-UWDunaujvaros	37	30	11	200612	200702
3	TAS/ME	20780002	TA	AnsaldoSistemiIndusMilano-IT	TCS00	IR-	215	40	86	200612	200704
4	TAS/ME	20780002	TA	AnsaldoSistemiIndusMilano-IT	FVR00	IR-	26	40	10	200612	200704
5	TAS/ME	20780002	TA	AnsaldoSistemiIndusMilano-IT	FVR00	IR-	20	40	8	200612	200704
6	TAS/ME	20780002	TA	AnsaldoSistemiIndusMilano-IT	FVR00	IR-	16	40	6	200612	200704
7	TAS/ME	20780002	TA	AnsaldoSistemiIndusMilano-IT	CPR00	IR-	10	40	4	200612	200704
Tabelle1

as long as the number in B is the same, the values of the column E should be put together by commas and the values of G and I should be summarized. Again I want to have a new resulting table with all previous values -

- column A, C, D, F, H, J, K stay the same
- the value of column B is now unique
- column E are all different items with commas
- column G is the sum of all Gs with the same number
- column I is the sum of all Is with the same number

regards