Jan 11 2022 09:25 PM
Jan 11 2022 09:58 PM
Hello, maybe there is something more simple with an excel formula. Attached is an excel file with a possible solution using power query.
Just copy your data in the table "Information" and go to the ribbon data > refresh all (like a pivot table)
Jan 11 2022 10:49 PM - edited Jan 11 2022 11:02 PM
@Chehak Attached file contains two formula based solutions. One that will work in MS365 / Excel 2021. The other with traditional formulae that need copy and paste down and across. See which one works for you.
As an alternative, something similar can be achieved with Power Query, though less straightforward if you are not accustomed with the tool.
Edit: New file attached including the PQ solution.
Jan 13 2022 05:02 PM
Jan 13 2022 05:03 PM