Hi Team,
I need your support on below query.
Please find attached input and required output tab for your reference.
I am tried with cross tab and summarize tools but i am unable to finished this with proper outcome - could you please help me out on this, thanks.
Input:
Identifier | Source | group1 | group2 |
AED | amer | 0.273 | 78.78 |
AED | euro | 0.275 | 79.23 |
RED | amer | 89.3 | 89.2 |
RED | euro | 88.2 | 89.8 |
BMW | amer | 98.5 | 97.5 |
BMW | euro | 98.7 | 97.388 |
GHE | amer | 63 | 89 |
Required Output given below
Identifier | type | amer | euro | type | amer | euro |
AED | Group1 | 0.273 | 0.275 | Group2 | 78.78 | 79.23 |
RED | Group1 | 89.3 | 88.2 | Group2 | 89.2 | 89.8 |
BMW | Group1 | 98.5 | 98.7 | Group2 | 97.5 | 97.388 |
GHE | Group1 | 63 | Group2 | 89 |
Thanks for the logic - what happens in case if i have more groups.
example : group1,group2,group3,group4,Group5
Hi - Thanks for your support.
May i know the further logic please- what if more then 2 groups ?
like apart from only group1 and group2 ...we have group3, group4 ,group5.
thanks for logic - but for me it showing as below error.