If/then statements

[lechat]

Hello,

I am trying to align a column of data with a neighboring column so that the data is in one continuous row.

For instance, this is how the data looks now:
Bill (e.g. A2
5 (neighboring column, one space down. e.g. B3)
Chrissy
8 (neighboring column, one space down)
Dan
3 (neighboring column, one space down)

And I want it as:
Bill (A2) 5 (B2)

Chrissy 8 ..etc.

Dan 3 ..etc.

where names remain alphabetical as is but the numbers just align to the names, not sorted ascending or descending in any way.

I assume an if/then statement can fix this.

How can I go about doing this?

Thanks

 

[Jerry Sullivan]

Hi and Welcome to the Board,

From your description, it isn't clear what Cells Chrissy and Dan start in.
If they are in Column A directly below Bill, you would be able to select Cell B1, then Delete > Shift Cells Up.

Excel Workbook
	A	B
1	Bill
2		5
3	Chrissy
4		8
5	Dan
6		3
Sheet

If I misintepreted that, please post screen shots like this one showing your Before and After images.