I am having trouble programming an Excel 2007 worksheet. The data is horizontal. My goal is to put it in a vertical format without the redundant information. Example: all employee names and ID's will be on one row and the month dates will be on one of the column header fields. This problem has to be resolved with VBA

Help.

Thanks

Richard