jimgima
New Member
- Joined
- Sep 19, 2006
- Messages
- 26
I'm a training manager for the Air Force and I'm trying to make my job easier. So, here's the quick of it.
I receive a weekly product that lists everyone's training in my squadron. Here is the format (condensed)
Name____Emp#__Class____Due Date
Jim Jan___123____M16____12 dec 08
Jim Jan___123____SABC___20 mar 07
Jim Jan___123____LOAC___10 dec 06
Jim Jan___123____Forklift__20 dec 08
Jim Jan___123____AF Train_12 dec 08
Bob Man__543____M16_____9 mar 07
Bob Man__543____LOAC____10 nov 06
Bob Man__543____SABC____23 dec 07
And so on... it's a few thousand lines of data.
I want to have the data rearranged to look like this:
Name____Emp#____SABC_____LOAC_____Forklift______M16
Jim Jan___123_____20 mar 07__10 dec 06__20 dec 08___12 dec 06
Bob Man__543_____23 dec 07__10 Nov 06_____________9 Mar 07
This way people can look at their name and see if they have any training due. I'm not sure how I would even begin to do this. Please take it easy on me... I'm not an idiot, but I'm not a brain either.
Thanks,
Jim
I receive a weekly product that lists everyone's training in my squadron. Here is the format (condensed)
Name____Emp#__Class____Due Date
Jim Jan___123____M16____12 dec 08
Jim Jan___123____SABC___20 mar 07
Jim Jan___123____LOAC___10 dec 06
Jim Jan___123____Forklift__20 dec 08
Jim Jan___123____AF Train_12 dec 08
Bob Man__543____M16_____9 mar 07
Bob Man__543____LOAC____10 nov 06
Bob Man__543____SABC____23 dec 07
And so on... it's a few thousand lines of data.
I want to have the data rearranged to look like this:
Name____Emp#____SABC_____LOAC_____Forklift______M16
Jim Jan___123_____20 mar 07__10 dec 06__20 dec 08___12 dec 06
Bob Man__543_____23 dec 07__10 Nov 06_____________9 Mar 07
This way people can look at their name and see if they have any training due. I'm not sure how I would even begin to do this. Please take it easy on me... I'm not an idiot, but I'm not a brain either.
Thanks,
Jim