Copying pasting sorting macro

[abberyfarm]

Hello there,

I have a difficult copying and pasting question/request.

I have data in column c, example below.

I need to copy and paste it horizontally starting in cell H1.

However, it is subject to a number of conditions.

1. If there is any duplicate data in column, only paste one instance of it in the row.
2. I also need to paste them in order according to the first value.

Example:

C                 H
0,0              0,0  1,1  1,-2  1,0  1,-2 1,-1  2,-2  3,6 3,0 3,-6 5,10   
1,1
3,6
5,10
3,-6
1,-2
1,0
3,6
3,0
1,-2
3,6
2,-2
1,-1

I appreciate your help.

Thank you

 

[Comfy]

If you have excel 2007 you can use builtin functions.

Select you data.

Goto Data > Remove Duplicates
Goto Data > Sort
Copy your data, right click where you wish the data to start, choose paste special and the Transpose.

 

[abberyfarm]

Thank you