Populate column with corresponding row values grouped by lab test (row to column)

[newbieX]

I have an Excel 2007 spreadsheet that contains lab results that I want to import into Access. I need to reformat the data so that all the toxicology results are on a single row based on their LabNumber with only one row per lab number.

My data looks like this:

Excel 2007

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Species	Type	Method	LabNumber	CustNumber	Arsenic	Barium	Cadmium	Calcium	Chromium	Cobalt	Copper	Iron
2	Goat	Serum	ICP	V1001245	MTGT Pink 60		26.4
3	Goat	Serum	ICP	V1001245	MTGT Pink 60							0.44
4	Goat	Serum	ICP	V1001245	MTGT Pink 60			0.78
5	Goat	Serum	ICP	V1001245	MTGT Pink 60				91.7				1.82
6	Goat	Serum	ICP	V1001245	MTGT Pink 60					43.7
7	Goat	Serum	ICP	V1001246	MTGT Pink 67	23.6
8	Goat	Serum	ICP	V1001246	MTGT Pink 67							1.24
9	Goat	Serum	ICP	V1001246	MTGT Pink 67		0.738
10	Goat	Serum	ICP	V1001246	MTGT Pink 67				83.2				0.769
11	Goat	Serum	ICP	V1001246	MTGT Pink 67						63.7
12	Goat	Serum	ICP	V1001247	MTGT Pink 73	26.2
13	Goat	Serum	ICP	V1001247	MTGT Pink 73							0.738
14	Goat	Serum	ICP	V1001247	MTGT Pink 73		0.875
15	Goat	Serum	ICP	V1001247	MTGT Pink 73				89.9				0.97
16	Goat	Serum	ICP	V1001247	MTGT Pink 73			56.9
17	Goat	Blood - Whole	ICP-MS	V1001257	MTGT Pink 60					0.06443
18	Goat	Blood - Whole	ICP-MS	V1001258	MTGT Pink 67					0.06987
19	Goat	Blood - Whole	ICP-MS	V1001259	MTGT Pink73				0.1001

<tbody>
</tbody>

Sheet1​

I want it to look like this:

Excel 2007

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Species	Type	Method	LabNumber	CustNumber	Arsenic	Barium	Cadmium	Calcium	Chromium	Cobalt	Copper	Iron
2	Goat	Serum	ICP	V1001245	MTGT Pink 60		26.4	0.78	91.7	43.7		0.44	1.82
3	Goat	Serum	ICP	V1001246	MTGT Pink 67	23.6	0.738		83.2		63.7	1.24	0.769
4	Goat	Serum	ICP	V1001247	MTGT Pink 73	26.2	0.875	56.9	89.9			0.738	0.97
5	Goat	Blood - Whole	ICP-MS	V1001257	MTGT Pink 60					0.06443
6	Goat	Blood - Whole	ICP-MS	V1001258	MTGT Pink 67					0.06987
7	Goat	Blood - Whole	ICP-MS	V1001259	MTGT Pink73				0.1001

<tbody>
</tbody>

Sheet2
​

Does anyone have a solution as to how to accomplish this? We have several files in this format thus an automation process that can be used over and over again is preferred.