Rearraging numbers so column c before is column a in next row

[Fire7467]

Rearranging numbers so column c before is column a in next row but also need it to but the last c row number in the next row if it applies

Pipe DTH03528 DJ-0936 Pipe DTH04898 Pipe DTH02677 MLA-0435 Pipe DTH03024 Pipe DTH05084 DJ-0925 Pipe DTH04298 Pipe DTH02033 DJ-0261 Pipe DTH03952 Pipe DTH03896 MLA-0434 Pipe DTH03528 Pipe DTH04291 DJ-0922 Pipe DTH03348 Pipe DTH02130 MLA-0445 Pipe DTH03824 Pipe DTH04898 MLA-0433 Pipe DTH03482 Pipe DTH04639 MLA-0432 Pipe DTH05084 Pipe DTH04292 MLA-0446 Pipe DTH03378 Pipe DTH03348 MLA-0430 Pipe DTH02881 Pipe DTH04171 DJ-0263 Pipe DTH03795 Pipe DTH03824 DJ-0945 Pipe DTH04908 Pipe DTH01743 MLA-0183 Pipe DTH04171 <colgroup><col><col span="2"></colgroup><tbody> </tbody>

<tbody>
</tbody>

 

[Fire7467]

This would be a better example

Pipe DTH03528	DJ-0936	Pipe DTH04898	Pipe DTH03528	DJ-0936	Pipe DTH04898
Pipe DTH02677	MLA-0435	Pipe DTH03024	Pipe DTH04898	MLA-0433	Pipe DTH03482
Pipe DTH05084	DJ-0925	Pipe DTH04298	Pipe DTH03482	#N/A	#N/A
Pipe DTH02033	DJ-0261	Pipe DTH03952	Pipe DTH05084	DJ-0925	Pipe DTH04298
Pipe DTH03896	MLA-0434	Pipe DTH03528	Pipe DTH04298	MLA-0431	Pipe DTH04291
Pipe DTH04291	DJ-0922	Pipe DTH03348	Pipe DTH04291	DJ-0922	Pipe DTH03348
Pipe DTH02130	MLA-0445	Pipe DTH03824	Pipe DTH03348	MLA-0430	Pipe DTH02881
Pipe DTH04898	MLA-0433	Pipe DTH03482	Pipe DTH02881	DJ-0931	Pipe DTH03553
Pipe DTH04639	MLA-0432	Pipe DTH05084	Pipe DTH03553	MLA-0429	Pipe DTH04278
Pipe DTH04292	MLA-0446	Pipe DTH03378	Pipe DTH04278	DJ-0927	Pipe DTH00645
Pipe DTH03348	MLA-0430	Pipe DTH02881	Pipe DTH00645	MLA-0428	Pipe DTH04625
Pipe DTH04171	DJ-0263	Pipe DTH03795	Pipe DTH04625	DJ-0923	Pipe DTH04213
Pipe DTH03824	DJ-0945	Pipe DTH04908	Pipe DTH04213	MLA-0427	Pipe DTH02870
Pipe DTH01743	MLA-0183	Pipe DTH04171	Pipe DTH02870	#N/A	#N/A
				#N/A
				Pipe DTH00903	#N/A	#N/A
				#N/A
				Pipe DTH02677	MLA-0435	Pipe DTH03024
				Pipe DTH03024

<colgroup><col><col span="2"><col><col><col span="2"></colgroup><tbody>
</tbody>

 

[Fire7467]

I would like to thank kweaver alot for his assistance