Pivot worksheet

Phoenix Certara Forums Phoenix WNL basics
1

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 (162 KB)

2

Please try the mapping attached.

Bernd

pivot.png
pivot.png1173×446 17.8 KB

3

Thank you Bernd!

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

LLLi

4

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

5

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 (37.3 KB)