질문하기

Lighton Phiri's profile - activity

2016-09-25 17:16:47 +0200 받은 배지  자서전 작가
2015-09-05 23:55:09 +0200 받은 배지  유명한 질문 (source)
2014-06-11 17:38:41 +0200 받은 배지  훌륭한 질문 (source)
2014-05-27 21:07:25 +0200 받은 배지  주목할 만한 질문 (source)
2014-05-27 17:11:24 +0200 코멘트달린 답변 Melt summarised data using Calc

You Sir, just saved me the pain of manually copy-pasting a whole LOT of entries--a million thank yous for this.

One would have thought a feature working in the opposite direction of say the PIVOT function would be in-built within Calc.

2014-05-27 17:08:49 +0200 받은 배지  학자 (source)
2014-05-27 17:08:41 +0200 받은 배지  조력자 (source)
2014-05-27 10:35:23 +0200 받은 배지  인기있는 질문 (source)
2014-05-27 05:18:38 +0200 받은 배지  학생 (source)
2014-05-27 02:57:02 +0200 질문에 댓글을 달았습니다 Melt summarised data using Calc

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

2014-05-27 02:39:33 +0200 받은 배지  편집자 (source)
2014-05-27 02:35:33 +0200 질문하였습니다 Melt summarised data using Calc

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