merging two columns based on an identifying tag but with different data

[erika320]

Excel 2010

	A	B	C	D	E	F	G	H	I	J
2	Student Name	ID Number	Grade	Days absent	% Absent	Number of Fs	ODR (? no pass, truancy, class cuts)	% Absent	Number of Fs	ODR (? no pass, truancy, class cuts)
3	sample, student	555142	10	0	0%
4	sample, student	555142	10					1	5%

<tbody>
</tbody>

Summary Sheet​

I have the above data. I am looking to merge the two columns into one, so that I end with:
Excel 2010

	A	B	C	D	E	F	G	H	I	J
1	Student Name	ID Number	Grade	Days absent	% Absent	Number of Fs	ODR (? no pass, truancy, class cuts)	% Absent	Number of Fs	ODR (? no pass, truancy, class cuts)
2	sample, student	555142	10	0	0%			1	5%

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet3​

I am using the ID number as the identifying information and am using it to perform Vlookups from other spreadsheets.

I am new to macros and excels but I think I pick things up quickly. ANY help you can provide would be appreciated. I think I've seen this question a few times from other people but have not seen the answer. If you know it was answered and could point me in the right direction I'd appreciate that too!

Thank you,
Erika