Search : in
By :

Replacing data from one column to another

Sabbir, on Oct 9, 2008 9:02:00 am BST 
 Report this message to moderators

Hello,

Is anybody help me please? I need to move data from second column to first column only if there is any data in second column. More clearly speaking in column D I have integer data almost in all row, in column G there are some integer data in few row, what I need is to cut data from column G (if exists) then paste in column D in same row(overwrite). This is not replacing column G to column D fully, only there is any value in G then cut it and replace it in corresponding row of column D.

volume of data is huge so doing this manually takes long time. Can I do it using simple formula or Macro or VB code ?

Configuration: Windows XP
Internet Explorer 7.0

Best answers for « Replacing data from one column to another » in :
Adding data from one column using another Show Adding data from one column using another Issue Solution Note Issue I am having a real problem with an Excel formula. I have a worksheet with variable rows and a number of columns. I need to add together the values of particular...
Transferring data from one hard drive to another ShowTransferring data from one hard drive to another First of all you should use some tools.. transfering data from one hard drive to another is quite simple. Once you have connected the new hard drive to your pc, check your...
Transforming columns into lines ShowTransforming columns into lines Example Limitations It is endemic for most Linux tools to work with lines, but not with columns (sed, awk, grep, etc..). However, it may happens,that you have a file where the data should be read in...
Replacing the battery of your motherboard (CMOS battery) ShowReplacing the battery of your motherboard (CMOS battery) Topics Symptoms Replacement sequence Saving the BIOS data Identify the CMOS battery Removing the discharged battery Installing the new battery Verify the BIOS data and resetting...
Download Mandriva One ShowMandriva One is the easiest and most secure to test and adopt Linux. The download and installation is so quick that you do not have to touch your existing data through the "live CD". After installation, it offers a functional office and support...
Download Aqua Data Studio ShowAqua Data Studio is an advanced SQL editor. It can create, edit and execute SQL scripts. This software provides an integrated database with only one interface for connecting to databases. Query Analyzer enables users to work on RDBMS synthax and auto...
Data transmission - Cabling ShowCabling types Several physical data-transmission media are available to connect together the various devices on a network. One possibility is to use cables. There are many types of cables, but the most common are: Coaxial cable Double twisted...
Network topology ShowWhat does "topology" mean? A computer network is made of computers which are linked to one another with communication lines (network cables, etc.) and hardware elements (network adapters, as well as other equipment for ensuring that data travels...
Data transmission - The physical connection ShowWhat is a transmission channel? A transmission line is a connection between two machines. The term transmitter generally refers to the machine that sends the data while receiver refers to the one receiving the data. The machines can sometimes be...