What would be the best method to split columns into rows (like matrix?)
Example table:

```
Name Hours1 Hours2 Hours3
Jon  32     40     30
Ana  40     0      40

```

Result (don't show 0 values):

```
Name Hours
Jon  32
Jon  40
Jon  30
Ana  40
Ana  40

```

One way I can think of doing this is by using `Union`

```
SELECT
  Name,
  Hours1
FROM #HOURSTABLE
WHERE Hours1 <> 0

UNION ALL

SELECT
  Name,
  Hours2
FROM #HOURSTABLE
WHERE Hours2 <> 0

UNION ALL

SELECT
  Name,
  Hours3
FROM #HOURSTABLE
WHERE Hours3 <> 0

```

Any other suggestion?