Melt summarised data using Calc [closed]

asked 2014-05-27 02:35:33 +0100

Lighton Phiri gravatar image

updated 2014-05-27 05:57:52 +0100

karolus gravatar image

I have summarized input data that I would like to expland into a desired output format as shown below. I essentially want to work backwards and 'melt' the summaries. I've been poking around Calc for the last couple of hours and cannot seem to figure out how. Any thoughts?

Input data

Column1       Column2      Count 
X             A            2  
X             B            3  
Y             A            4  
Y             B            1   
Z             B            2

Desired output

Column1  Column2  
X        A  
X        A  
X        B  
X        B  
X        B  
Y        A  
Y        A  
Y        A  
Y        A  
Y        B  
Z        B  
Z        B

Update #1: Changed input and output headers
Update #2: set ExampleData as Code Karolus

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2016-02-23 21:34:22.191597


Sorry, but at least I would need a bit more information on what the strings under Input Data and Desired Output mean.

ROSt52 gravatar imageROSt52 ( 2014-05-27 02:49:14 +0100 )edit

The strings are merely arbitrary row entries. I've just renamed the column headers--I'm hoping that will clear things up a little.

Lighton Phiri gravatar imageLighton Phiri ( 2014-05-27 02:57:02 +0100 )edit