I have a StockLines table in MsSql 2017. It has columns:

```
 Product, QuantityInStock, ReservedQuantity.
 CocaCola        50                20

```

Now I need to display that info in 2 rows:

```
Product      Quantity         Reserved
CocaCola        20              true
CocaCola        30              false

```

Is it possible to achive using Pivot()? Am I on a correct path?
P.S I'm using Entity Framework Core.