I'm looking for a way to convert data from columns to replicates in Graphpad Prism v7.02.

Here is a screenshot of some sample data in a column:

Sample data in column

Here is a screenshot of what I'm hoping to convert it to:

Data as Replicates

When I try to do this using

Analyze Data -> Transform, Normalize... -> Transpose X & Y

the output gives me each row in a separate column

Result of Transpose X and Y

This would be OK if I could find a way to convert two adjacent columns into replicates, but I can't find that. I do know how to do it using Miscrosoft Excel, but I would prefer a one-step process.

Please let me know if you have suggestions.

  • If someone with more than 300 reputation points would be so kind, please will you create a tag "graphpad-prism" and I will assign this question to it. Thank you!
    – Freda K
    Feb 14, 2017 at 20:36

1 Answer 1


Use Copy -> Paste Special

Copy the data from cells the first data table ("Data 1") Group A, rows 1 through 6 using Control-C

Select all 6 cells to copy

Create a new "Grouped" data table with the desired number of replicates ("Data 2").

Paste the data from "Data 1" into "Data 2" using Paste Special
* On the "Source" tab select "Insert and maintain link"
* On the "Placement" tab select "Transpose. Each row becomes a column"

Paste Special Source

Paste Special Placement

Alternatively, right click the destination cell and Paste Transpose -> Link

Copy over column and row names similarly, with or without transposing.

The data in "Data 2" will now be updated when "Data 1" is updated, and can be used for analysis and to make graphs.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.