Been racking my brains over this for a while now and still cant quite figure it out.
In the attachment I have a line of data for multiple resources with a corresponding date and number of hours to be spent on the project.
I need to arrive at one line per resource with the corresponding date items on one line just moved up and deduped if that makes sense.
Whenever I try and resolve it I and up looping myself to death.
Any help would be greatly appreciated.
Desired Result attached also, sorry