HI Friends,

I copied data from several files and I need to make sure the Text I had copied in to different columns fall in the same row.

Using Column A as the base, I need tocompare columns C, E,G,I,L,N,P. Making sure all Text in the these columns fall in the same row as Column A. Once checked i'll later be deleting C, E,G,I,L,N,P.

I have also showed the desired answers.

Below is the link to the sample file

http://speedy.sh/wq3A6/Make-sure-row...same-line.xlsx

Thanks