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...o&userid=34742
View this thread: http://www.excelforum.com/showthread...hreadid=545029