Let's say, I have a table from log, it looks like this:
[Log Table](https://i.stack.imgur.com/08oXm.png)

I need a result table like:
[Result table](https://i.stack.imgur.com/rPQS4.png)

But the problem is my dataset is not only 7, but maybe 24, 100 value columns.
My query with 7 value columns is:

```
select 
*
from My_Dataset
unpivot 
(status for value in (value_1, value_2, value_3, value_4, value_5, value_6, value_7))```

But is there anyway to automatic this process for value_n?
Thank you.

```