Member Avatar for exonwarrior
exonwarrior

Hey all,
I'm working a spreadsheet in excel. Basically, it looks like this:
In Column A there's a 4-digit number. Column B, there's 2 things one cell with an entry like this A0000000, for example, and right under that, a 4-digit number. Column C is a person's name. what I want to do is take every 2nd cell in column B (the one with a 4-digit number) and MOVE it to Column D, so each entry is in one row. So it would look like this:
A B C D
1111 A00000000 John Doe 2222

Any ideas?