Say I have a set of data that consists of a data field and an identifier field. There are much more distinct data than there are identifiers.. I would like to split this set in a pivot table into one field containing the identifiers and one field that contains the data. Furthermore I want the be able to open and collapse the identifier field, in order to show or hide the data as I please. How do I go about?
Thanks in advance for your reply