Merging duplicate cells

[oxhaksi]

Hi
I am using Excel 2007 and i wanted to know if i could merge duplicate cells in one column in one cell, but the cells are in random order e.x

F1     R1   0.7
F3     R6   0.2
F5     R5   0.1
F1     R3   0.5
F3     R2   0.6

and so on.
I want to know if there is a button so that it will make my[COLOR=blue ! important][FONT=Verdana,Helvetica,sans-serif][COLOR=blue ! important][FONT=Verdana,Helvetica,sans-serif][/FONT][/FONT][/COLOR][/COLOR] data look like this

F1   R1    0.7
     R3    0.5
F3  R5    0.1
     R2    0.6
F5   R5   0.1

Thank you in advance

 

[iliace]

PivotTable will do that for you, although it won't transform the actual data rather it will make a copy. Use the PivotTable Wizard (Tools menu), then use the F and R columns as rows (you'll need to give them headers) and the number column as data.

Excel Workbook
	A	B	C
1	F	R	Number
2	F1	R1	0.7
3	F3	R6	0.2
4	F5	R5	0.1
5	F1	R3	0.5
6	F3	R2	0.6
7
8
9
10	Sum of Number
11	F	R	Total
12	F1	R1	0.7
13		R3	0.5
14	F3	R2	0.6
15		R6	0.2
16	F5	R5	0.1
17	Grand Total		2.1
Sheet2

A1:C6 is the original data; A10:C17 is the PivotTable.