可以使用CROSS JOIN执行此操作，如下所示：

select 
  c.col as Task,
  case c.col
    when 'Housing' then Housing
    when 'Furniture' then Furniture
    when 'YardWork' then YardWork
  end as Time
from mytable t
cross join
(
  select 'Housing' as col
  union all select 'Furniture'
  union all select 'YardWork'
) c

此处仅列出一列：

select 
      c.col as Task,
      case c.col
        when 'Housing' then Housing
      end as Time
    from mytable t
    cross join
    (
      select 'Housing' as col
    ) c

Demo here