Note: You must be registered in order to post a reply. To register, click here. Registration is FREE!
T O P I C R E V I E W
OriginPhil
Posted - 01/16/2014 : 05:01:56 AM Hello, is there a way to unstack a bunch of columns formatted like this:
into something like this:
Col(A) now consists of the sorted values from col(B) in the origin sheet, and col(B) to col(E) contain the values from the origin col(C), unstacked and grouped by the values of the original col(A). I am aware of the unstacking function, and I can create something like this:
but I'm missing the option to create the desired new col(A), as shown in the 2nd picture.
Thanks in advance for any help!
Phil
1 L A T E S T R E P L I E S (Newest First)
lkb0221
Posted - 01/16/2014 : 09:47:12 AM Hi, Philipp
Open unstack dialog by selecting "Worksheet: Unstack Columns" and do the following setting:
1). "Data to Unstacked" = col(C) 2). "Group Columns" = Col(A) 3). Check "Include Other Columns" checkbox. 4). "Other Columns" = Col(B) 5). "Extract Rule for Other Columns Values" = "Combining All Groups"