Replacing Contents of 1 Cell to Another.

J

John1950

My Spreadsheet looks like below.

A B C

207 MDIM3030 3 TRUE
208 MDIM3030 FALSE
209 MDIM3034 1 TRUE
210 MDIM3034 FALSE
211 MDIM3038 6 FALSE
211 MDIM3039 4 FALSE

I have sorted by Column "A" and done an EXACT on them.

Now I need to know how to, for example on cell, B:207 (3) and move i
to the blank cell below and so on through the Column. There ar
hundreds of lines on the column, so I am looking for a quick way o
doing this. Can anyone please help?

Thank you
 
Top