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
Automatically extract only relevant data from a worksheet into a new one? 3
Count Occurances of String in a Column? 4
Sort 6
Inserting Columns based on missing headers 4
Dynamic Range Using INDEX instead of Offset 4
Summing cells based on mulitiple criteria over mulitple columns 1

Top