For fixed numbers of columns, you can do something like this:

select message,

max(case when type='id' then value end) as 'ID',

max(case when type='matl' then value end) as 'Malt',

max(case when type='svisor' then value...

create view zeroos_v1

as

select right(replicate('0',7)+field1,7)

from the_entity

go