lundi 9 septembre 2019

How to transpose into the "same" column?

I have a table like

<table class="tg">
  <tr>
    <th class="tg-0lax">date</th>
    <th class="tg-0lax">organic</th>
    <th class="tg-0lax">referrer</th>
    <th class="tg-0lax">direct</th>
  </tr>
  <tr>
    <td class="tg-0lax">01.01.2019</td>
    <td class="tg-0lax">12345</td>
    <td class="tg-0lax">123</td>
    <td class="tg-0lax">23</td>
  </tr>
  <tr>
    <td class="tg-0lax">25.01.2019</td>
    <td class="tg-0lax">23456</td>
    <td class="tg-0lax">234</td>
    <td class="tg-0lax">34</td>
  </tr>
  <tr>
    <td class="tg-0lax">03.03.2019</td>
    <td class="tg-0lax">34567</td>
    <td class="tg-0lax">345</td>
    <td class="tg-0lax">56</td>
  </tr>
  <tr>
    <td class="tg-0lax">15.04.2019</td>
    <td class="tg-0lax">45678</td>
    <td class="tg-0lax">456</td>
    <td class="tg-0lax">78</td>
  </tr>
</table>

I want to get the data into this view, where all data are placed into the same three columns, not dependently of whether points in the first column are repeated:

<table class="tg">
  <tr>
    <th class="tg-0lax">type</th>
    <th class="tg-0lax">source</th>
    <th class="tg-0lax">date</th>
  </tr>
  <tr>
    <td class="tg-0lax">organic</td>
    <td class="tg-0lax">12345</td>
    <td class="tg-0lax">01.01.2019</td>
  </tr>
  <tr>
    <td class="tg-0lax">referrer</td>
    <td class="tg-0lax">123</td>
    <td class="tg-0lax">01.01.2019</td>
  </tr>
  <tr>
    <td class="tg-0lax">direct</td>
    <td class="tg-0lax">23</td>
    <td class="tg-0lax">01.01.2019</td>
  </tr>
  <tr>
    <td class="tg-0lax">organic</td>
    <td class="tg-0lax">23456</td>
    <td class="tg-0lax">25.01.2019</td>
  </tr>
  <tr>
    <td class="tg-0lax">referrer</td>
    <td class="tg-0lax">234</td>
    <td class="tg-0lax">25.01.2019</td>
  </tr>
  <tr>
    <td class="tg-0lax">direct</td>
    <td class="tg-0lax">34</td>
    <td class="tg-0lax">25.01.2019</td>
  </tr>
  <tr>
    <td class="tg-0lax">organic</td>
    <td class="tg-0lax">34567</td>
    <td class="tg-0lax">03.03.2019</td>
  </tr>
  <tr>
    <td class="tg-0lax">referrer</td>
    <td class="tg-0lax">345</td>
    <td class="tg-0lax">03.03.2019</td>
  </tr>
  <tr>
    <td class="tg-0lax">direct</td>
    <td class="tg-0lax">56</td>
    <td class="tg-0lax">03.03.2019</td>
  </tr>
  <tr>
    <td class="tg-0lax">organic</td>
    <td class="tg-0lax">45678</td>
    <td class="tg-0lax">15.04.2019</td>
  </tr>
  <tr>
    <td class="tg-0lax">referrer</td>
    <td class="tg-0lax">456</td>
    <td class="tg-0lax">15.04.2019</td>
  </tr>
  <tr>
    <td class="tg-0lax">direct</td>
    <td class="tg-0lax">78</td>
    <td class="tg-0lax">15.04.2019</td>
  </tr>
</table>

The "normal" transposing is pretty close to what I want, but even not exactly this, and I miss the point, how to pivot the data.

Another one example:

enter image description here

Aucun commentaire:

Enregistrer un commentaire