CREATE TABLE Original
(
   KeyFieldId 	    int
   ,FieldName  	    char(1)
   ,AlphaNumeric	varchar(20)
   ,JustNumeric	decimal
   ,DateField	datetime
)
CREATE TABLE Transformed
(
   KeyFieldId	int
   ,ColX		varchar(20)
   ,ColY		decimal
   ,ColZ		datetime
)

INSERT INTO Original VALUES (1, 'x', 'Trays A10/6',NULL , NULL)
INSERT INTO Original VALUES (1, 'y', NULL ,10.1, NULL)
INSERT INTO Original VALUES (1, 'z', NULL, NULL, '11/10/2002')

INSERT INTO Original VALUES (2, 'x', 'Drums', NULL, NULL)
INSERT INTO Original VALUES (2, 'y', NULL, 056, NULL)
INSERT INTO Original VALUES (2, 'z', NULL, NULL, '10/10/2002')