# Pivot worksheet

**URL:** <https://forum.certara.com/t/pivot-worksheet/3047>\
**Category:** Phoenix WNL basics\
**Created:** [October 12, 2016, 6:52pm UTC](https://forum.certara.com/t/pivot-worksheet/3047 "2016-10-12T18:52:14Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![llli](https://avatars.discourse-cdn.com/v4/letter/l/b9bd4f/32.png) [@llli](https://forum.certara.com/u/llli)\
**Post date:** [October 12, 2016, 6:52pm UTC](https://forum.certara.com/t/pivot-worksheet/3047/1 "2016-10-12T18:52:14Z")

</div>

Hi All,

I tried to transform a set of stacked data into a set of pivoted data (just like from the final parameters to the final parameters pivoted in NCA results).

In the projected attached, I can transform worksheet 1 (stacked data) to worksheet 2 (pivoted data) by using split and then merge worksheet. I am wondering if this transformation can be done by simply using Pivot worksheet. If yes, how to map the data?

Please see the project attached for more detail.

Thank you!

LLLi

[Pivot worksheet.phxproj](https://forum.certara.com/uploads/short-url/w8rsovN2RcRsIgK7zhM0wYbD5eE.phxproj) (162 KB)

---

<div class="post-metadata">

**Author:** ![bwendt](https://avatars.discourse-cdn.com/v4/letter/b/f4b2a3/32.png) [@bwendt](https://forum.certara.com/u/bwendt)\
**Post date:** [October 12, 2016, 7:23pm UTC](https://forum.certara.com/t/pivot-worksheet/3047/2 "2016-10-12T19:23:00Z")

</div>

Please try the mapping attached.

Bernd

 ![pivot.png](https://us1.discourse-cdn.com/certara/original/2X/0/0428fb8836c4176146b58c1b7835d93474456451.png)

---

<div class="post-metadata">

**Author:** ![llli](https://avatars.discourse-cdn.com/v4/letter/l/b9bd4f/32.png) [@llli](https://forum.certara.com/u/llli)\
**Post date:** [October 12, 2016, 8:32pm UTC](https://forum.certara.com/t/pivot-worksheet/3047/3 "2016-10-12T20:32:59Z")

</div>

Thank you Bernd!

I have another question about the Data Wizard. Can it remove duplicate by some factors as we do in excel?

LLLi

---

<div class="post-metadata">

**Author:** ![SimonDavis](https://avatars.discourse-cdn.com/v4/letter/s/d9b06d/32.png) [@SimonDavis](https://forum.certara.com/u/SimonDavis)\
**Post date:** [October 13, 2016, 11:12am UTC](https://forum.certara.com/t/pivot-worksheet/3047/4 "2016-10-13T11:12:53Z")

</div>

LLLi, I’m not sure what you mean.

perhaps you need to summarise data with e.g. desc stats first?

Perhaps if you add to your project an example of the start and desired end point we can help

Simon

---

<div class="post-metadata">

**Author:** ![llli](https://avatars.discourse-cdn.com/v4/letter/l/b9bd4f/32.png) [@llli](https://forum.certara.com/u/llli)\
**Post date:** [October 13, 2016, 2:02pm UTC](https://forum.certara.com/t/pivot-worksheet/3047/5 "2016-10-13T14:02:41Z")

</div>

Hi Simon,

Sorry for the confusion. Please see the file attached. I want to remove duplicate by term, class and week. I can do that in excel. I am wondering if I can so the same thing in WinNonlin. Sometimes I had to export the results to excel to revise and then imported the revised result to WinNonlin to continue my work.

Thanks,  
LLLi

[Remove duplicate.phxproj](https://forum.certara.com/uploads/short-url/uyrsqxBkxGykWg2wlQMuaB4t8db.phxproj) (37.3 KB)