Using pivot table without summing, etc.

[Peter Bernadyne]

Hello,

I have data in the following format:

Date SMBL
Data
1 A
10
2 A
12
3 A
13
4 B
40
5 B
42
6 B
46

and I need to get it into the following format:

DATE
SMBL 1 2 3 4
5 6
A 10 12 13
B 40
42 46


with 'Data' being returned in the middle. Can I use a pivot table t
do this? I've tried it a couple of times but it seems it will only d
this and return a sum/max/min/average/var, whatever of the data rathe
than the datapoints themselves (so I don't need a count of 10 for A i
Date 1, which would give me '1', I need the actual datapoint, in thi
case '10').

Can anyone show me how I might rearrange my worksheet using pivot tabl
in this way?

Thanks in advance

 

[Frank Kabel]

Hi
do you have only one value for each combination of date and SMBL?

--
Regards
Frank Kabel
Frankfurt, Germany

"Peter Bernadyne" <[email protected]>
schrieb im Newsbeitrag
news[email protected]...