Hello guys
I need to consolidate values distributed underneath columns represented by Days.
I just need the consolidation of these values by Category as per period (Week, Month and Year).
Due the quantity of information in my file, using a formula is not feasible. The file has +2k columns and +27k rows.
I tried using pivot tables, but it recognize the column dates as a field instead as a date.
The final report will be something like below. Where the first column either is Week or Month as per year.
I need to consolidate values distributed underneath columns represented by Days.
I just need the consolidation of these values by Category as per period (Week, Month and Year).
Due the quantity of information in my file, using a formula is not feasible. The file has +2k columns and +27k rows.
Column A | Column B | Column C | Column D | Column E | Column F | Column G | Column H | (...) |
Id | Category | 01/01 | 01/02/2020 | 01/03/2020 | 01/04/2020 | 01/05/2020 | 01/06/2020 | (...) |
1 | A | $124 | $230 | $31 | $43 | $21 | $190 | $ |
2 | B | $250 | $18 | $35 | $178 | $420 | $221 | $ |
3 | C | $30 | $75 | $470 | $12 | $340 | $110 | $ |
I tried using pivot tables, but it recognize the column dates as a field instead as a date.
The final report will be something like below. Where the first column either is Week or Month as per year.
Year | Category A | Category B | Category C |
Wk#1 | $ | $ | $ |
Wk#2 | $ | $ | $ |
Wk#3 | $ | $ | $ |
(...) | $ | $ | $ |