Do we have ANY way to catigorize (map) the date automaticly?
It seems to be lengthy process to this task manually - we have 100+ rows on this example, and real world data can be way more than that. However, i tride to came up with a way to auto-catigorize the data but unforently i couldn`t, can you pleaese help?
Regards,
2 answers ( 0 marked as helpful)
Hello,
There isn't another way:) The best you can do is help yourself with filters if there are items with repeating titles.
Best,
Ned
I believe that if we have the file in Excel, it will be possible to use power query to merge it based on the P&L account or even Vlookup or index-Match if I am not mistaken. Can you guys provide the Excel version of the mapping explained pdf file?