Hello I have a table like this:
Company Name|Account Name|2018 Amount|2019 Amount
ACB|Revenue| $$$$|$$$$$
EFC|Revenue
EFG| Costs
ABC|Costs
EEE|Revenue
EEE|Costs|
EEE| EBITA
and I want the data table to be like this"
Account name| ABC|EEE|EFG
Revenue | $$$$|$$$$|$$$$
Cost
EBITA
Can you please help to on how to get this done? Thank you!
Hi @Holidayday
Here is how you can do it.
workflow:
1. Using transpose tool converting columns to rows with key as company name & account name
2. Using crosstab tool with key as account name & name (years) converting back to table with company name as name and value as value. This gives a year level breakdown
or
2. Using crosstab tool with key as account name converting back to table with company name as name and value as value. This gives a sum of years.
Hope this helps 🙂