Transpose rows and columns

Question

Hello Everyone!

I have a table like this;

YearMonthTypeTarget 1Target 220211Mobile60 20212Mobile60 20213Mobile60 20214Mobile60 20215Mobile60 20216Mobile60 20217Mobile60 20218Mobile60 20219Mobile60 202110Mobile60 202111Mobile60 202112Mobile60 20211Mobile 8020212Mobile 8020213Mobile 8020214Mobile 80

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

YearMonthTypeTarget 1Target 220211Mobile608020212Mobile608020213Mobile608020214Mobile608020215Mobile608020216Mobile608020217Mobile608020218Mobile608020219Mobile6080202110Mobile6080202111Mobile6080202112Mobile6080

Thanks in advance!!

atcodedog05 · Accepted Answer

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 Answer

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!