vba to pivot data

[JannetteChristie]

I have the following data on a spreadsheet:

Excel 2012
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Line Type	Qte Line No.	Product	Technical Info	Additional Items
2	Booster Set	1	VR3-0510-LHM	DUTYPOINT	3	FS5-WRAS	1	COMM1	1	FRB50	2
3	Standard	2	DE		0
4	Standard	3	qp-35	PRESSURISATION	0
5	Standard	4	ec50	CONDITIONER	2	DPS-WMB-EC50	2	DPS-FMB-EC50	1
6	Standard	5	cx65c	SEP	0
7	Standard	6	in15-50-p-h2	HIU	0
8	Special	7	DPS-SP		1	DPS-NOTE	1
Save & Print prepare

Excel 2012

#DAE7F5 ;color: #161120">Save & Print prepare​

How do I easily turn it into the following layout in another column on my sheet:
Excel 2012
Excel 2012

	T	U
VR3-0510-LHM
FS5-WRAS
COMM1
FRB50
DE
QP-35
EC50
DPS-WMB-EC50
DPS-FMB-EC50
IN15-50-P-H2
DPS-SP
DPS-NOTE

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]2[/TD]

[TD="align: right"][/TD]

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

[TD="align: right"]1[/TD]

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

[TD="align: right"]1[/TD]

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

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

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

[TD="align: right"][/TD]

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

[TD="align: right"][/TD]

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

[TD="align: right"][/TD]

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

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

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

[TD="align: right"]1[/TD]

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

[TD="align: right"][/TD]

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

[TD="align: right"][/TD]

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

[TD="align: right"]1[/TD]

</tbody>

Save & Print prepare






#DAE7F5 ;color: #161120">Save & Print prepare​