title: Filter dataframe for values that are below or exceed min/max value that is specified in a column
body: <p>I have a dataframe of values and I want to filter and transpose the dataframe if the quarterly value is under the MinRange or over the MaxRange. Values are ignored if it is inbetween the min/maxrange.</p>
  <pre><code>Name  MinRange MaxRange 2020Q1 2020Q2 2020Q3 2020Q4
  Test1 15       20       13     16     24     17
  Test2 18       25       14     15     23     19
  Test3 30       39       31     29     24     37
  </code></pre>
  <p>Desired Result:</p>
  <pre><code>Quarter Name  MinRange MaxRange Value
  2020Q1  Test1 15       20       13
  2020Q3  Test1 15       20       24
  2020Q1  Test2 18       25       14
  2020Q2  Test2 18       25       15
  2020Q2  Test3 30       39       29
  2020Q3  Test3 30       39       24
  </code></pre>
  <p>Does any ideas on how I could tackle this?</p>