Convert some rows to column

Sai Lao

<div>Hi all, </div>
<div> </div>
<div>Is there any way to generate following example ?</div>
<div> </div>
<div>Example : </div>
<div> </div>
<div> </div>
<div><strong>Result Dataset:</strong></div>
<div>Name<span> </span>    Time <span> </span>                 City<span> </span>           Arrived Time</div>
<div>

---

</div>
<div>David<span> </span>     01-01-2016<span> </span>       London<span> </span>     11:12</div>
<div>David<span> </span>     01-01-2016<span> </span>       Paris<span> </span>         23:11</div>
<div>David<span> </span>     01-02-2016<span> </span>       London<span> </span>     09:10</div>
<div>Kam<span> </span>       01-02-2016<span> </span>       London<span> </span>     10:11</div>
<div> </div>
<div><strong>converted and show as follow:</strong></div>
<div> </div>
<div>Name<span> </span>    Time<span> </span>                London<span> </span>           Paris</div>
<div>

---

</div>
<div>David<span> </span>     01-01-2016<span> </span>     11:12<span> </span>              23:11</div>
<div>David<span> </span>     01-02-2016<span> </span>     09:10<span> </span>              00:00</div>
<div>Kam<span> </span>       01-02-2016<span> </span>     10:11<span> </span>              00:00</div>
<div> </div>
<div>Is it possible? I tried with Cube but still no luck. </div>
<div> </div>
<div>Please let me know. Thanks</div>

pricher

<p>Hi,</p>
<p> </p>
<p>Pivoting the result dataset with a cube works well, as shown in the attached example:</p>
<p> </p>
<p>