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