automating cut and paste?

hi,

ok, my spreadsheet looks something like this;

6 Aldershot
1 Aldershot
7 Aldridge-Brownhills
2 Aldridge-Brownhills
8 Altrincham & Sale W
3 Altrincham and Sale West

and I want it to look like this;

6 Aldershot 1 Aldershot
7 Aldridge-Brownhills 2 Aldridge-Brownhills
8 Altrincham & Sale W 3 Altrincham and Sale West


is this possible without manually cutting and pasting? Also, some of the data is similar but not exactly the same.

ON EDIT: I should point out that I only want to cut and paste the data to columns C & D if it is the same/similar to the data directly above it (before cut and pasting).

thanks
Liam

Originally Posted by LiamF

hi,

ok, my spreadsheet looks something like this;

6 Aldershot
1 Aldershot
7 Aldridge-Brownhills
2 Aldridge-Brownhills
8 Altrincham & Sale W
3 Altrincham and Sale West

and I want it to look like this;

6 Aldershot 1 Aldershot
7 Aldridge-Brownhills 2 Aldridge-Brownhills
8 Altrincham & Sale W 3 Altrincham and Sale West


is this possible without manually cutting and pasting? Also, some of the data is similar but not exactly the same.

ON EDIT: I should point out that I only want to cut and paste the data to columns C & D if it is the same/similar to the data directly above it (before cut and pasting).

thanks
Liam

Hi see the attached file

Originally Posted by LiamF

Thanks, it's weird but this works on one or two rows of data but mostly i'm getting the #VALUE! in the cell.

Also, I didn't really make it clear that, for example, that;

6 Aldershot

the "6" and "Aldershot" are in different cells ie. Column A & B


regards
Liam

see the attached file.
note that you need to put the matching values (i-e same values) in each appearance
e.g if you enter Altrincham and Sale West first time then you should not enter it as Altrincham & Sale W.
it means text in col B should be with same words at each of its appearance in col B.

Originally Posted by LiamF

OK, that works although it puts the result all in one cell eg. Column C.
Anyway to avoid that? so that ;

1 Aldershot

are in different Columns (C & D)


thanks
Liam

see the attach file (more comprehensive)

Originally Posted by LiamF

still not quite there with this. See if my attached spreadsheet makes any sense.

many thanks
Liam

Hi LiamF

download file from link below

http://www.megaupload.com/?d=2UOCMGK0