I've got a fairly simple transpose issue that I can seem to figure out. I found my old post completed by Capricorn1 and that did not solve my problem and I can't figure out what is wrong.
So I have data like this with say 4 Departments.
What I need it to look like is:
Due Task A B C D
1/1/2015 Eat Lunch 1/1/2015 N/A (no task for D)
1/2/2015 Go Home 1/2/2015 1/2/2015 1/2/2015
From the transposed data, you can quickly see that Dept A has not completed either task, B is Ok, C has one task yet, and D only had one task as they didn't need to eat lunch for some reason (maybe the were fasting).
I spent probably more time that I should have trying figure this out. Capricorn1 if you see this.... Others you may be able to help.