Filter data for specific column and add remarks for blanks
Hello,
Here’s my sample dataset.
| TYPE | Jul | Aug | Sep | Jul (#1) | Aug (#1) | Sep (#1) | Jul (#2) | Aug (#2) | Sep (#2) | Jul (#3) | Aug (#3) | Sep (#3) |
| ABC | T1 - Tagging | | | T2 - Tagging | | | T1 - Tagging Vol | | | T2 - Tagging Vol | | |
| ABC | | | | | | | | | | | | |
| ABC | 0 | 0 | 210 | 0 | 0 | 214 | 0 | 0 | 87570 | 0 | 0 | 188700 |
| ABC | 0 | 0 | 783 | 0 | 0 | 55 | 0 | 0 | 83400 | 0 | 0 | 130000 |
| ABC | 0 | 0 | 783 | 0 | 0 | 55 | 0 | 0 | 78300 | 0 | 0 | 130000 |
| ABC | 0 | 0 | 130 | 0 | 0 | 55 | 0 | 0 | 316300 | 0 | 0 | 130000 |
| ABC | 0 | 0 | 30 | 0 | 0 | 55 | 0 | 0 | 110900 | 0 | 0 | 188700 |
| ABC | 0 | 0 | 3 | 0 | 0 | 4 | 0 | 0 | 11500 | 0 | 0 | 188700 |
| ABC | 0 | 0 | 783 | 0 | 0 | 845 | 0 | 0 | 326511 | 0 | 0 | 188700 |I have only two expected output:
How can I copy the remarks for example under Jul column, copy the “T1 - Tagging” to Aug and Sep. Then for Jul (#1) to Aug (#1) and Sep (#1), so on and so forth.
May I ask how can I filter a specific column or months, for example, this month is Sep, so it will only filter the months for Sep, Sep (#1), etc. Then next month, for example the month will be, December, then it will get Dec, Dec (#1), etc. Is it possible to make it as variable?
| TYPE | Sep | Sep (#1) | Sep (#2) | Sep (#3) |
| ABC | T1 - Tagging | T2 - Tagging | T1 - Tagging Vol | T2 - Tagging Vol |
| ABC | | | | |
| ABC | 210 | 214 | 87570 | 188700 |
| ABC | 783 | 55 | 83400 | 130000 |
| ABC | 783 | 55 | 78300 | 130000 |
| ABC | 130 | 55 | 316300 | 130000 |
| ABC | 30 | 55 | 110900 | 188700 |
| ABC | 3 | 4 | 11500 | 188700 |
| ABC | 783 | 845 | 326511 | 188700 |Similar case to item #2, it is just that what if I want to get 2 months which is current and prior month. Assuming today’s month is September, so it will get Sep and Aug.
| TYPE | Aug | Sep | Aug (#1) | Sep (#1) | Aug (#2) | Sep (#2) | Aug (#3) | Sep (#3) |
| ABC | T1 - Tagging | T1 - Tagging | T2 - Tagging | T2 - Tagging | T1 - Tagging Vol | T1 - Tagging Vol | T2 - Tagging Vol | T2 - Tagging Vol |
| ABC | | | | | | | | |
| ABC | 0 | 210 | 0 | 214 | 0 | 87570 | 0 | 188700 |
| ABC | 0 | 783 | 0 | 55 | 0 | 83400 | 0 | 130000 |
| ABC | 0 | 783 | 0 | 55 | 0 | 78300 | 0 | 130000 |
| ABC | 0 | 130 | 0 | 55 | 0 | 316300 | 0 | 130000 |
| ABC | 0 | 30 | 0 | 55 | 0 | 110900 | 0 | 188700 |
| ABC | 0 | 3 | 0 | 4 | 0 | 11500 | 0 | 188700 |
| ABC | 0 | 783 | 0 | 845 | 0 | 326511 | 0 | 188700 |Hope you can help me with this. Thank you so much!