Text and Numerical data in a Pivottable without summarising?
 

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

Text and Numerical data in a Pivottable without summarising?
 

You can create the layout you want on pages, rows and columns, and then use a
"dummy" measure for the data area (like the count of textValue, for example).
By dummy I mean that it won't be useful for you (you can even hide the
column), but you will have all the other columns with the layout you want.

Hope this helps,
Miguel.

"Madhouse" wrote:


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