All Forums  Origin Forum  Origin Forum  "StackCols" doesn't account for yEr designation

Note: Only the poster of this message, and the Moderator can edit the message.

Screensize: 640 x 480 800 x 600 1024 x 768 1280 x 1024 UserName: Password: Anti-Spam Code: Format Mode: Basic  Help  Prompt  Format: Font Andale Mono Arial Arial Black Book Antiqua Century Gothic Comic Sans MS Courier New Georgia Impact Lucida Console Script MT Bold Stencil Tahoma Times New Roman Trebuchet MS Verdana   Size 1 2 3 4 5 6   Color Black Red Yellow Pink Green Orange Purple Blue Beige Brown Teal Navy Maroon LimeGreen Forum: Origin Forum Subject: Message: * HTML is OFF * Forum Code is ON Smilies Hi all. I'm trying to restructure a worksheet with a bunch of data sets, where I have essentially three rows, e.g. for a material, and then a set of columns for variables that have been obtained from tests under 4 different testing parameters. Right now my worksheet is structured as shown in the screenshot below, where column A is the material, the Long Name of the other columns is the variable and in the "Descriptor" field is the test parameter. Each variable is an average value with the standard deviation in the column next to it. [img]https://my.originlab.com/ftp/forum_and_kbase/Images/Column-Stacking.jpg[/img] I would now like to stack these columns based on either the Long Name or the Descriptor, maintaining the connection between the Avg. and StdDev columns. However, the "Stack Columns" function does not recognize the designation as yEr and just treats it as standard columns and therefore producing an output that looks like this (I've highlighted the cells with from the StdDev in green): [img]https://my.originlab.com/ftp/forum_and_kbase/Images/Column-Stacked.jpg[/img] Is there any way to properly process such data sets or does this need to be done manually? In any case, would you otherwise suggest to have a completely different structure of the base worksheet to make working with it easier? Thanks for your help! Best, Lucas OriginPro 2024 (64-bit) SR1; 10.1.0.178 Operating System: Windows 10   Check here to subscribe to this topic.