Hi All,
Would anyone be able to offer some advice on how to convert a cross table to a list in Excel 2010 as per the following example please? Basically i have a number of resource tracking worksheets (one per site) and the staff fill in their days per site as planned and worked. I was able to convert this into a list with VBA, but now need to include a code for the type of work. Adding the code to the list has me stumped.
I have this:
<tbody>
</tbody>
Any help gratefully received!!
Thanks
Would anyone be able to offer some advice on how to convert a cross table to a list in Excel 2010 as per the following example please? Basically i have a number of resource tracking worksheets (one per site) and the staff fill in their days per site as planned and worked. I was able to convert this into a list with VBA, but now need to include a code for the type of work. Adding the code to the list has me stumped.
I have this:
DATE | Adam planned | Adam worked | Adam Code | Beth planned | Beth worked | Beth Code |
01/01/2013 | 0.0 | 1.0 | A | 0.0 | 1.0 | C |
02/01/2013 | 0.5 | 1.0 | B | 0.5 | 1.0 | B |
And want this: | ||||||
Date | Name | Type | Value | Code | ||
01/01/2013 | Adam | Planned | 0 | A | ||
01/01/2013 | Adam | Worked | 1 | A | ||
01/01/2013 | Beth | Planned | 0 | C | ||
01/01/2013 | Beth | Worked | 1 | C |
<tbody>
</tbody>
Any help gratefully received!!
Thanks