In the value area section of a normal Pivot Table one can only show the result of aggregation functions such as SUM(), COUNT(), AVERAGE() etc. Even if one drags a text field to the value area section of a Pivot Table, one cannot show those text fields because they automatically get counted. Consider the following […]
Read More →
Here is a 2 column dataset – UserID in column A and Remarks in Column B. This dataset basically tabulates the remarks/comments shared by different users. Entries in the Remarks column are basically free flowing text entries which have the following inconsistencies/nuances: Users reported multiple errors which are separated by comma, Alt+Enter (same line within […]
Read More →
Imagine a dataset like this. This dataset shows vendors that submitted proposals for supplying various parts to a Company. There is one column for each of the twelve months. Via a simple Pivot Table, one can determine the lowest bidding vendor per product (part) for any chosen month. However, one may also want to know […]
Read More →
Imagine a multi column exam invigilation schedule with the following information S. No. Name of staff Designation of staff member Two columns for each day on which there is an exam – one for Morning and another for Afternoon A * under each column if that particular staff member has to be an invigilator during […]
Read More →
Here’s a simple two column dataset Comment Identifier Intervals A 3pm-6pm A 9pm-12pm S 3pm-6pm S 3pm-6pm S 9pm-12pm A 9pm-12pm S 9pm-12pm D 3pm-6pm A 9pm-12pm A 9pm-12pm A 9pm-12pm A 3pm-6pm A 3pm-6pm For identifiers listed in column A, there are time intervals in column B. Note that for a certain identifier, a […]
Read More →
Show text entries in the value area section of a Pivot Table after meeting certain conditions
{ 0 Comments }