I can do the pivot data with additional column using SQL but I NEED to do the following in excel:
Change this :->
Year Quarter Name Income
1900 Q1 ABC 1
1900 Q2 ABC 1
1900 Q3 ABC 1
1900 Q4 ABC 2
1900 Q1 XYZ 3
1900 Q2 XYZ 3
1900 Q3 XYZ 3
1900 Q4 XYZ 5
To :->
Year Name Income_Q1 Income Q2 Income Q3 Income Q4
1900 ABC 1 1 1 2
1900 XYZ 3 3 3 5
I hope some excel guru can guide me.
-Nick
Change this :->
Year Quarter Name Income
1900 Q1 ABC 1
1900 Q2 ABC 1
1900 Q3 ABC 1
1900 Q4 ABC 2
1900 Q1 XYZ 3
1900 Q2 XYZ 3
1900 Q3 XYZ 3
1900 Q4 XYZ 5
To :->
Year Name Income_Q1 Income Q2 Income Q3 Income Q4
1900 ABC 1 1 1 2
1900 XYZ 3 3 3 5
I hope some excel guru can guide me.
-Nick