I'm really sorry if this has been answered before or there's an easy solution. I've looked and found nothing that quite helped me. I'm a newbie and very grateful for any help.
My problem isn't that complicated:
I have a sheet with projects that all have individual IDs, and another sheet with tasks that have also have individual Task-ID's and the ID of the project they belong to. There are some tasks belonging to a project.
The project sheetThe task sheetThe wanted result
What I want to do is automatically sorting the tasks under the project they belong to, similar to a normal to-do list. Again, any help would be appreciated.
I think VLOOKUP could be of use here, but honestly I'm not experienced enough to sort this out.