Pestomania
Active Member
- Joined
- May 30, 2018
- Messages
- 332
- Office Version
- 365
- Platform
- Windows
Good day,
How can I cycle through a much larger table than you see here, but with this formatting and rearrange the results to look like the second table below?
It rearranges them to put them in the correct format of:
First column = Date
Second Column = Qty (I exclude all zeroes from the new table)
Third Column = Program Name
How can I cycle through a much larger table than you see here, but with this formatting and rearrange the results to look like the second table below?
Program 1 | Program 2 | Program 3 | |
1/31/2024 | 84 | 63 | 0 |
2/29/2024 | 84 | 63 | 0 |
3/31/2024 | 84 | 63 | 7 |
4/30/2024 | 84 | 63 | 0 |
5/31/2024 | 84 | 63 | 7 |
6/30/2024 | 84 | 63 | 0 |
7/31/2024 | 84 | 63 | 0 |
8/31/2024 | 84 | 63 | 7 |
9/30/2024 | 84 | 63 | 0 |
10/31/2024 | 84 | 63 | 7 |
11/30/2024 | 84 | 63 | 0 |
12/31/2024 | 84 | 63 | 7 |
1/31/2025 | 84 | 63 | 0 |
2/28/2025 | 84 | 63 | 0 |
3/31/2025 | 84 | 63 | 7 |
4/30/2025 | 84 | 63 | 0 |
5/31/2025 | 84 | 63 | 7 |
6/30/2025 | 84 | 63 | 0 |
7/31/2025 | 84 | 63 | 0 |
8/31/2025 | 84 | 63 | 7 |
9/30/2025 | 84 | 63 | 0 |
1/31/2024 | 84 | Program 1 |
2/29/2024 | 84 | Program 1 |
3/31/2024 | 84 | Program 1 |
4/30/2024 | 84 | Program 1 |
5/31/2024 | 84 | Program 1 |
6/30/2024 | 84 | Program 1 |
7/31/2024 | 84 | Program 1 |
8/31/2024 | 84 | Program 1 |
9/30/2024 | 84 | Program 1 |
10/31/2024 | 84 | Program 1 |
11/30/2024 | 84 | Program 1 |
12/31/2024 | 84 | Program 1 |
1/31/2025 | 84 | Program 1 |
2/28/2025 | 84 | Program 1 |
3/31/2025 | 84 | Program 1 |
4/30/2025 | 84 | Program 1 |
5/31/2025 | 84 | Program 1 |
6/30/2025 | 84 | Program 1 |
7/31/2025 | 84 | Program 1 |
8/31/2025 | 84 | Program 1 |
1/31/2024 | 63 | Program 2 |
2/29/2024 | 63 | Program 2 |
3/31/2024 | 63 | Program 2 |
4/30/2024 | 63 | Program 2 |
5/31/2024 | 63 | Program 2 |
6/30/2024 | 63 | Program 2 |
7/31/2024 | 63 | Program 2 |
8/31/2024 | 63 | Program 2 |
9/30/2024 | 63 | Program 2 |
10/31/2024 | 63 | Program 2 |
11/30/2024 | 63 | Program 2 |
12/31/2024 | 63 | Program 2 |
1/31/2025 | 63 | Program 2 |
2/28/2025 | 63 | Program 2 |
3/31/2025 | 63 | Program 2 |
4/30/2025 | 63 | Program 2 |
5/31/2025 | 63 | Program 2 |
6/30/2025 | 63 | Program 2 |
7/31/2025 | 63 | Program 2 |
8/31/2025 | 63 | Program 2 |
3/31/2024 | 7 | Program 3 |
5/31/2024 | 7 | Program 3 |
8/31/2024 | 7 | Program 3 |
10/31/2024 | 7 | Program 3 |
12/31/2024 | 7 | Program 3 |
3/31/2025 | 7 | Program 3 |
5/31/2025 | 7 | Program 3 |
8/31/2025 | 7 | Program 3 |
It rearranges them to put them in the correct format of:
First column = Date
Second Column = Qty (I exclude all zeroes from the new table)
Third Column = Program Name