Text and Numerical data in a Pivottable without summarising?

Giganews Newsgroups
Subject: Text and Numerical data in a Pivottable without summarising?
Posted by:  Madhouse (Madhouse.28b7ny_1148470200.7529@excelforum-nospam.com)
Date: Wed, 24 May 2006

I have a database of mixed text and data, index by common dates which I
need to present as a single table, sorted by date;

Ie,

date1, StartTime, textValue
Date1, Runtime, NumberValue
Date2, StartTime, textValue
Date2, Runtime, NumberValue

becomes

------- StartTime ---- Runtime
Date1  textValue        NumberValue
Date2  textvalue        NumberValue

In principle this should be possible using a pivottable but that will
only summarise the data, in terms of Count, Sum, etc, which won't
handle the Textvalues at all.

Is it possible to just present the data 'As Is' rather than summarising
it and handling everying as though it were a number?

Thanks

--
Madhouse
------------------------------------------------------------------------
Madhouse's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=34742
View this thread:http://www.excelforum.com/showthread.php?threadid=545029

Replies