select columns to columns

Holidayday

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!

atcodedog05

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 🙂

costs.yxmd