how to consolidate a one date column, into multiple month columns?
i have multiple mini tables like this , each has a date for them and i need to transform them to the second picture without manually adding them
here is the consolidation result, each row is one table of the above, like the above here has cheques in month 7, 9, 11, 1 2027 and 3 2027, i want them to be in one row and the cheqs number for them, how can i consolidate this way?
note: other tables and date like the first picture are below it in the same sheet but without the blue row, you have the the values without the blue header, but for the yellow table it is the same
so basically it is duplicated for other units and names under each other without the blue header, everything else is the same
here is a sample of the raw data anonomized https://docs.google.com/spreadsheets/d/1Om52hJjpZs8mqxJXdKVGQFHzbI82xoCI/edit?usp=drive_link&ouid=102680896042905763738&rtpof=true&sd=true
[link] [comments]
Want to read more?
Check out the full article on the original site