Hello everybody and a nice evening. I have to admit that we totally fail at the moment to find a simple solution for two formal problems we have during a standard NCA regarding the final output for transfer of the results. 1. Due to an applicable SOP we are asked to provide the results in a pre-defined sequence of rows. For illustration, this shall be A-B-C-D (such as subject ID-period-treatment-AUC). Due to the calculation itself (including some merging here, some column transformation there etc.) our result sheet contains A-C-B-D. Back then in WinNonlin this was solved “by the way” due to the way the Merging worked, but now… Is there any way except Copy&Paste by hand to sort these columns? I would prefer to have this done automatically in a Workflow and not end up fiddling with my data in Excel. 2. And this may be even more surprising that someone does not know how to do, but: We also need to add some empty columns. Only a header, all cells empty. We now resolved this by a transformation such as >if(subject ID not empty; ‘NULL’)<. However, this is obviously a kind of trick and I think there might be another way implemented in Phoenix already. Any help or suggestion on these issues would be greatly appreciated and please do not hesitate to ask for further inforamtion, in case this was too confused or sparse information. With best regards and thanks for reading, Steven.
Hi Steven, There are a few ways to do this, but I think the most sensible way would be to have in your workflow template a column properties step in a Data Wizard object that will enable you to specify any column order you wish 
note the sort tab; 
Simon
Hello Simon. Thanks for the rapid reply and sorry for not replying similarly fast, I just had to leave the office. Thanks, that seems to do the job. We never thought about using that feature, as this will also define the way the rows are sorted. That is, if I need the column for concentration first and column of treatment second, using this approach will result in a data sheet wherein the rows are then sorted by concentration and thereafter for treatment. Nevertheless, the SOP only asks for a specific sequence of columns in the end and not for a specific sorting of the rows. And I think we can figure out the latter kind of sorting anyway in Excel or Sorting after copying to the data folder, if need be. That should be a “few clicks adventure” then. So thanks for this support, which really is appreciated. Best regards, Steven. As a side not for bulle 2: introducing a new column seems to be even more easier by using the “Data Wizard - Transformation” and enter a custom formula of >if(1=1,“”,“”)<. Even no need to keep the reference column valid. I like that.
Steven - actually your formula could be even simpler, just two quotes 
Or perhaps you have a worksheet ‘template’ of the blank columns that you merge in at the end? But what I forgot to ask you was what did you need these columns for? Simon
Hi Simon. I see, thanks for the simplification. In a nutshell, we have to provide columns with specific information for each parameter (e.g., if it applies to a NCA). We just filled it by hand back then in Winnonlin and, if possible, by means of a “by subject/parameter” algorithm now in Phoenix. That way we have it documented in the “Settings” and “History”, which is a nice bonus. But generally, these cells remain empty as the “standard setting” and, well, adding an empty column was “easier” in WinNonlin, I dare to say. But we want it automatically and we have to stay in Phoenix (no editing “outside the project”!). However, during implementation into the data base, existence and order (for whatever reason) of the pre-defined columns is checked and implementation is terminated, if it is not present. As I said in the subject, a “formality”, but in conclusion I think this is a nice and clean solution. Best regards, Steven.