Exchanging data

E

Eve

Hi,

I have an Excel 2007 file with text data in 2 columns like this:
X1 A
X2 B
X3 C
X4 D
X5 E
X6 F
etc.

For some purposes I have to save the date in another file
in the following way:
X1 B
X2 A
X3 D
X4 C
X5 F
X6 E
etc.

The file is big so it would be difficult to do it manually.
How to do it automatically?

Please help me.

Regards
Eve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to exchange data? 4
Sorting a string array containing combinations 4
Sum of row and column entries (database) 4
How to do it - please help me! Urgent. 1
Search a table using three criterion 0
How to do a 2-dimensional lookup? 0
"Combining 2 sheets" - urgent! 3
Automatically extract only relevant data from a worksheet into a new one? 3

Top