Hello,

I am looking to put a simple programme into a milestone related taks list with dates as below. I can't seem to get the table set up. Is there a way to do it outside of pivot tables or an easier way to set the pivot table up?

Programme   Source Data
DATE	25/11/2013	26/11/2013	27/11/2013	28/11/2013	29/11/2013	30/11/2013	01/12/2013	02/12/2013	03/12/2013	04/12/2013	05/12/2013
Footbridge 1		ItG		GR		ItC	CR		IFC
Footbridge 2	ItG		GR		ItC			CR		IFC
Ret wall 1			ItG		GR		ItC		CR		IFC
Ret wall 2				ItG		GR	ItC	CR	IFC
Gantry 1			ItG		GR		ItC		CR	IFC
Gantry 2		ItG			GR		ItC		CR	IFC
Pivot table form
Milestones	ItG	GR	ItC	CR	IFC
Footbridge 1	26/11/2013	28/11/2013	30/11/2013	01/12/2013	03/12/2013
Footbridge 2	25/11/2013	27/11/2013	29/11/2013	02/12/2013	04/12/2013
Ret wall 1	etc
Ret wall 2
Gantry 1
Gantry 2

Excel 2010 PivotTable
Google UnPivot.
No formulas, no code.
http://www.mediafire.com/download/yqlqcxiizbd748w/09_11_13.xlsx

Thank you for replying so soon.

I have sorted the Pivot table created from table 1

I am having trouble creating Table 1  - Is there anything obvious I should check for? Instead of Count of Value I am getting Count of Date. There is DATE and a list of dates to choose from in the fields to add to report.

Regards

Michael

• Edited by Michael Quinn HCL Wednesday, September 11, 2013 4:44 PM

Upload file to MediaFire.com or equivalent file sharing site.

http://www.mediafire.com/view/as2l9qvjyei7p47/Book1.xlsx

Excel 2010 PivotTable
Needed massive clean-up.
http://www.mediafire.com/download/421gpe282zstpom/09_13_13.xlsx