veit > microsoft.public.* > microsoft.public.office.excel

 #1  
01.04.2018, 15:54
jmslab
If somebody can help me out :)

I want to make a pivot table that shows the combined results.
For example

A normal pivot shows;

Naam: Likes:
Piet A
Klaas B
Kees C
Piet B
Kees D

a normal pivot shows as total:
Piet 2
Klaas 1
Kees 2

I like to create a pivot that shows;

Piet A; B
Klaas B
Kees C; D

As you can see, I don't want to show the number that names occur in the total list, I want to see the combined values related to the name.
Can somebody give me a guidance how to solve (or a site were I can read it).

regards, Johan
 #2  
01.04.2018, 17:15
TR
<jmslab> schreef in bericht
news:c0d4
[..]
> Piet 2
> Klaas 1
> Kees 2


In dat geval heb je dus een draaitabel gemaakt met:
Rijlabels: Naam
Waarden: Likes (aantal van Likes)

> I like to create a pivot that shows;
> Piet A; B
> Klaas B
> Kees C; D


Wat aardig in de buurt komt:
Rijlabels: Naam
Rijlabels: Likes

Dat ziet er dan uit als:

Kees
C
D
Klaas
B
Piet
A
B

Groet,

TR
 #3  
01.04.2018, 23:05
jmslab
TR ,

Thanks. But it doesn't combine the data (with a separator like the JoinText function) in one cell, like -> Piet A;B
Soortgelijke onderwerpen