THE former site of a Colchester supermarket which has been empty for three years is going to be transformed into a vibrant multi-use complex, the Gazette can reveal.