4 replies to this topic

[LLLi]

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

Attached Files

•  Pivot worksheet.phxproj   162.02KB   407 downloads

[bwendt@certara.com]

Please try the mapping attached.

 

Bernd

 

 

Attached Thumbnails

• 

[LLLi]

Thank you Bernd!

 

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

 

LLLi

[Simon Davis]

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

[LLLi]

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

Attached Files

•  Remove duplicate.phxproj   37.34KB   390 downloads