Hi,
Below solution is help full for you, any further clarification please reply here.
select USERID,
case when SignDay = 01 then AttStatus end '01',
case when SignDay = 02 then AttStatus end '02',
case when SignDay = 03 then AttStatus end '03',
case when SignDay = 04 then AttStatus end '04',
case when SignDay = 05 then AttStatus end '05',
case when SignDay IS NULL then AttStatus end 'No Day',
case when SignDay = '' then AttStatus end 'No Day'
from vwAttInOut
where userid=11 and year(signdate)=2015 and month(signdate)=08