Copying values

[Guest]

Hello People
I am just wondering if I have a spreadsheet with the following format
Test1 11
Test2 22
Test3 33
Test4 33
Test1 33
Test2 33
Test3 11
Test4 22
...
...
Is there a way to create another column and copy the value from Test1 directly to that new column?
eg.
11 Test1 11
Test2 22
Test3 33
Test4 33
33 Test1 33
Test2 33
Test3 11
Test4 22
Please Help me
Thank you

 

[Barrie Davidson]

On 2002-03-07 11:56, Anonymous wrote:
Hello People
I am just wondering if I have a spreadsheet with the following format
Test1 11
Test2 22
Test3 33
Test4 33
Test1 33
Test2 33
Test3 11
Test4 22
...
...
Is there a way to create another column and copy the value from Test1 directly to that new column?
eg.
11 Test1 11
Test2 22
Test3 33
Test4 33
33 Test1 33
Test2 33
Test3 11
Test4 22
Please Help me
Thank you

How about inserting a column and using an IF statement to populate that column? So your IF formula would be:

=IF(B1="Test1",C1,"")

Would that work for you?