Transpose rows and columns

[Jithesh]

Hello Everyone!

I have a table like this;

Year	Month	Type	Target 1	Target 2
2021	1	Mobile	60
2021	2	Mobile	60
2021	3	Mobile	60
2021	4	Mobile	60
2021	5	Mobile	60
2021	6	Mobile	60
2021	7	Mobile	60
2021	8	Mobile	60
2021	9	Mobile	60
2021	10	Mobile	60
2021	11	Mobile	60
2021	12	Mobile	60
2021	1	Mobile		80
2021	2	Mobile		80
2021	3	Mobile		80
2021	4	Mobile		80

I would want to have the table transposed like below, making it a nice table with all the information aligned.

Year	Month	Type	Target 1	Target 2
2021	1	Mobile	60	80
2021	2	Mobile	60	80
2021	3	Mobile	60	80
2021	4	Mobile	60	80
2021	5	Mobile	60	80
2021	6	Mobile	60	80
2021	7	Mobile	60	80
2021	8	Mobile	60	80
2021	9	Mobile	60	80
2021	10	Mobile	60	80
2021	11	Mobile	60	80
2021	12	Mobile	60	80

Thanks in advance!! 

[atcodedog05 · Accepted solution]

Hi @Jithesh 

You can use transpose and crosstab tool to get the desired output.

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

[kelsey_kincaid · Accepted solution]

Hi @Jithesh ,

There are a few different ways to accomplish this. The idea is to separate your records into two groups and then join them back together. Let me know if either of these methods works for you. If not, there are other ways we can try!

[Jithesh]

Thanks that was a quick solution 🙂

[Jithesh]

Thanks a lot :)!! 🙂