Which tool takes the provided input and creates
the provided output?
Input:
Record Category Color State
1 Car Black NH
2 Truck White CT
3 Car Black NH
4 Car Black CT
5 Truck White CT
6 Van White CT
7 Car Gray NH
8 Car White NH
Output:
Record Color Concat_State
1 Gray NH
2 White CT,CT,CT,NH
3 Black NH,NH,CT
A. Summarize
B. Text to Columns
C. Transpose
D. Cross Tab