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
sample, student
sample, student

<tbody>
[TD="align: center"]2[/TD]
[TD="bgcolor: #FFFFFF"]Student Name[/TD]
[TD="bgcolor: #FFFFFF"]ID Number[/TD]
[TD="bgcolor: #FFFFFF"]Grade[/TD]
[TD="bgcolor: #FFFFFF"]Days absent[/TD]
[TD="bgcolor: #FFFFFF"]% Absent[/TD]
[TD="bgcolor: #FFFFFF"]Number of Fs[/TD]
[TD="bgcolor: #FFFFFF"]ODR
(? no pass, truancy, class cuts)[/TD]
[TD="bgcolor: #CCC0DA"]% Absent[/TD]
[TD="bgcolor: #CCC0DA"]Number of Fs[/TD]
[TD="bgcolor: #CCC0DA"]ODR
(? no pass, truancy, class cuts)[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]555142[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FFFFFF, align: right"][/TD]
[TD="bgcolor: #CCC0DA, align: right"][/TD]
[TD="bgcolor: #CCC0DA, align: right"][/TD]
[TD="bgcolor: #CCC0DA, align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]555142[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #CCC0DA, align: right"]1[/TD]
[TD="bgcolor: #CCC0DA, align: right"]5%[/TD]
[TD="bgcolor: #CCC0DA, align: right"][/TD]

</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
sample, student

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="bgcolor: #FFFFFF"]Student Name[/TD]
[TD="bgcolor: #FFFFFF"]ID Number[/TD]
[TD="bgcolor: #FFFFFF"]Grade[/TD]
[TD="bgcolor: #FFFFFF"]Days absent[/TD]
[TD="bgcolor: #FFFFFF"]% Absent[/TD]
[TD="bgcolor: #FFFFFF"]Number of Fs[/TD]
[TD="bgcolor: #FFFFFF"]ODR
(? no pass, truancy, class cuts)[/TD]
[TD="bgcolor: #CCC0DA"]% Absent[/TD]
[TD="bgcolor: #CCC0DA"]Number of Fs[/TD]
[TD="bgcolor: #CCC0DA"]ODR
(? no pass, truancy, class cuts)[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]555142[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0%[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FFFFFF, align: right"][/TD]
[TD="bgcolor: #CCC0DA, align: right"]1[/TD]
[TD="bgcolor: #CCC0DA, align: right"]5%[/TD]
[TD="bgcolor: #CCC0DA, align: right"][/TD]

</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