hi all,
i have a data set looks like below, this is only 4 month period so in the end there will be 24 month data.
Status | Count | End Date (Updated) |
Pending Action | 2 | 01_Apr_2020 |
Pending Action | 71 | 01_Apr_2021 |
Pending Action | 1 | 08_Apr_2020 |
Pending Action | 68 | 08_Apr_2021 |
Pending Action | 1 | 15_Apr_2020 |
Pending Action | 54 | 15_Apr_2021 |
Pending Action | 88 | 22_Apr_2021 |
Pending Action | 62 | 29_Apr_2021 |
Pending Receipt | 1 | 01_Apr_2020 |
Pending Receipt | 51 | 01_Apr_2021 |
Pending Receipt | 52 | 08_Apr_2021 |
Pending Receipt | 56 | 15_Apr_2021 |
Pending Receipt | 64 | 22_Apr_2021 |
Pending Receipt | 51 | 29_Apr_2021 |
Rejected | 3 | 01_Apr_2020 |
Rejected | 26 | 01_Apr_2021 |
Rejected | 33 | 08_Apr_2021 |
Rejected | 31 | 15_Apr_2021 |
Rejected | 2 | 22_Apr_2020 |
Rejected | 42 | 22_Apr_2021 |
Rejected | 2 | 29_Apr_2020 |
Rejected | 29 | 29_Apr_2021 |
Pending Action | 19 | 04_Feb_2020 |
Pending Action | 75 | 04_Feb_2021 |
Pending Action | 11 | 18_Feb_2020 |
Pending Action | 50 | 18_Feb_2021 |
Pending Action | 11 | 25_Feb_2020 |
Pending Action | 57 | 25_Feb_2021 |
Pending Receipt | 14 | 04_Feb_2020 |
Pending Receipt | 87 | 04_Feb_2021 |
Pending Receipt | 11 | 18_Feb_2020 |
Pending Receipt | 103 | 18_Feb_2021 |
Pending Receipt | 11 | 25_Feb_2020 |
Pending Receipt | 63 | 25_Feb_2021 |
Rejected | 7 | 04_Feb_2020 |
Rejected | 34 | 04_Feb_2021 |
Rejected | 9 | 18_Feb_2020 |
Rejected | 42 | 18_Feb_2021 |
Rejected | 6 | 25_Feb_2020 |
Rejected | 16 | 25_Feb_2021 |
so after using cross tab tool, is it possible to have something looks like below? thanks so much guys
Status | 04_Feb_2020 | 04_Feb_2021 | 18_Feb_2020 | 18_Feb_2021 | 25_Feb_2020 | 25_Feb_2021 | 01_Apr_2020 | 01_Apr_2021 | 08_Apr_2020 | 08_Apr_2021 | 15_Apr_2020 | 15_Apr_2021 | 22_Apr_2020 | 22_Apr_2021 | 29_Apr_2020 | 29_Apr_2021 |
Pending Action | 19 | 75 | 11 | 50 | 11 | 57 | 2 | 71 | 1 | 68 | 1 | 54 | 88 | 62 | ||
Pending Receipt | 14 | 87 | 11 | 103 | 11 | 63 | 1 | 51 | 52 | 56 | 64 | 51 | ||||
Rejected | 7 | 34 | 9 | 42 | 6 | 16 | 3 | 26 | 33 | 31 | 2 | 42 | 2 | 29 |
Solved! Go to Solution.
Hi @Haokun - The solution posted by Akimasa will sort columns in alphabetical order. Let us know, if you want to sort them differently, e.g. chronological order.
that is not I am looking for...i don't want to have chronological order, i want to follow the output structure, so that it is able to compare year 2020 and year 2021 for different month. So the date and month will be in chronological order, not the year.
@Haokun
Inspired by @AkimasaKajitani
@Qiu it works man....thanks again for your help!
Glad to help and thank you for the accept mark.