If there is a previous thread for this topic, please direct me to it.
I have a large table (both in columns and rows). In each row/record, there are three name fields. The same name could be in any record, in any of the three fields. I need a way to put all of the names from those three fields into ONE field of a Pivot Table. Here is an example of what I am trying to do (NOTE: the dashes (-) are not part of the table, I've used them here to line up the columns):
Sample source data:
Record One----Name1--Name2--Name3
Record Two----Name1--Name4--Name5
Record Three--Name3--Name6--Name7
Pivot Table results I’m looking for:
Name1--Record One
------------RecordTwo
Name2--Record One
Name3--Record One
------------RecordThree
Name4--Record Two
Name5--Record Two
Name6--Record Three
Name7--Record Three
I am open to other methods of accomplishing the results I need. I already have one, but it has three times as many rows as my source table, which eventually will become unmanageable, I'm afraid.
I have a large table (both in columns and rows). In each row/record, there are three name fields. The same name could be in any record, in any of the three fields. I need a way to put all of the names from those three fields into ONE field of a Pivot Table. Here is an example of what I am trying to do (NOTE: the dashes (-) are not part of the table, I've used them here to line up the columns):
Sample source data:
Record One----Name1--Name2--Name3
Record Two----Name1--Name4--Name5
Record Three--Name3--Name6--Name7
Pivot Table results I’m looking for:
Name1--Record One
------------RecordTwo
Name2--Record One
Name3--Record One
------------RecordThree
Name4--Record Two
Name5--Record Two
Name6--Record Three
Name7--Record Three
I am open to other methods of accomplishing the results I need. I already have one, but it has three times as many rows as my source table, which eventually will become unmanageable, I'm afraid.