How to align columns

I think that this should do what you want.

There's a workbook at https://app.box.com/shared/elrnbidnr7 that will do this (part shown)

Row\Col	A	B	C	D	E	F	G	H	I
1	ID	RIGHT EXAM	RIGHT SCORE	RIGHT SURGERY		ID	LEFT EXAM	LEFT SCORE	LEFT SURGERY
13	14	01/27/1992	6			14	01/27/1992	6
14	15	01/17/1992	-1			15	01/17/1992	7
15						16	01/09/1992	6
16	17	08/20/1991	-1			17	08/20/1991	-1
17	19	01/16/1992	6			19	01/16/1992	5	04/16/1991
18	20	01/17/1991	9			20	01/17/1991	6	01/01/1979
19	22	01/06/1992	-1	09/09/1991		22	01/06/1992	6	01/23/1991
20	27	04/15/1991	9	12/04/1991
21	28	09/06/1989	9	09/26/1990		28	09/06/1989	12	09/20/1989
22	29	05/03/1990	6			29	05/03/1990	-1	03/19/1984
46	61	12/22/1988	4			61	12/22/1988	5
47	62	05/02/1985	6			62	05/02/1985	9
48	63	01/03/1984	12
49	64	02/27/1985	-1			64	02/27/1985	-1
50	65	02/09/1990	9			65	02/09/1990	-1

The rows that are hidden above just for compactness will not be hidden in the file.

Then you can use newdoverman's formulas.

The workbook at the link aligns those rows.

I don't know why the macro ran that you were given by shg doesn't work correctly. I hope that it can be fixed.

I used worksheet formulae to solve the problem...I hope.

I inserted a new column A and inserted the numbers starting at 2 and filled down the column. I then inserted columns to shift the original data over to column T and beyond.

With the new ID numbers in column A, I used VLOOKUP to find the IDs for both the right and left eyes.

Sorry for the inconvenience.

I ran the macro by shg with your data without problems...PERFECT

You're welcome. Thank you for the feedback.