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 🙂

[bharatandalam]

Hi @Holidayday 

Please have look at the attached workflow