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>

 

[kweaver]

Do you mean to place ALL of the current column C below the current column A but still leave it in place in column C as well...as it shows in your example?

Is there anything that goes into the new rows in either column B or C?

Sub MoveColC()
Dim LR As Long
LR = Cells(Rows.Count, "A").End(xlUp).Row
'assume header in row 1
'copy column C below existng column A
Range("C2:C" & LR).Copy Destination:=Range("A" & LR + 1)
End Sub

 

[Fire7467]

Do you mean to place ALL of the current column C below the current column A but still leave it in place in column C as well...as it shows in your example?

Is there anything that goes into the new rows in either column B or C?



the rows need to stay the same about to look at the script

 

[Fire7467]

sorry just got off, I need it to read like this

Pipe DTH03528	DJ-0936	Pipe DTH04898
Pipe DTH04898	MLA-0433	Pipe DTH03482
Pipe DTH05084	DJ-0925	Pipe DTH04298
Pipe DTH04298	MLA-0431	Pipe DTH04291
Pipe DTH04291	DJ-0922	Pipe DTH03348
Pipe DTH03348	MLA-0430	Pipe DTH02881
Pipe DTH02881	DJ-0931	Pipe DTH03553
Pipe DTH03553	MLA-0429	Pipe DTH04278
Pipe DTH04278	DJ-0927	Pipe DTH00645
Pipe DTH00645	MLA-0428	Pipe DTH04625
Pipe DTH04625	DJ-0923	Pipe DTH04213
Pipe DTH04213	MLA-0427	Pipe DTH02870
Pipe DTH02870	DJ-0930	Pipe DTH00903
Pipe DTH00903	#N/A	#N/A

<colgroup><col><col><col></colgroup><tbody>
</tbody>

not use to scripts on Excel was trying to use formulas but Im runing into a loop cause I need to cross verify and Im trying to use a true/false if this already in the column my formula is as follows ingore the 1s and 2s not sure what happened was saying true or false but think you get it

A=COUNTIF($F$1:$F$9996,B8) B-D is info Im trying to sort E=IFNA(H10,VLOOKUP(FALSE,$B$1:$F$10000,2,FALSE)) F=VLOOKUP(F8,welds!$B$1:welds!$C$10015,2,FALSE) G

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

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

 

[Fire7467]

I have a space in my excel thats way it says H as forgot G=VLOOKUP(B1,$B$1:$C7726,3,FALSE)

 

[kweaver]

I'm afraid I still don't understand what you want...maybe provide more info while I continue to look at it.

 

[Fire7467]

Trying to make a chain.. have random numbers associated together in rows in the row there is 3 columns the 1st column is the head asset the 3rd is behind so the next (2)row needs the 1st rows 3rd column in column 1 and the number associated with the row its in in the third column and so on to make a chain.. the chain is in pieces at the moment so there will be loose end but still need those the same way

 

[kweaver]

In post #4 , is the top table where it begins and the bottom table in that post is what you want to end up with?

The bottom table has Pipe DTH02677 but the top table doesn't have that anywhere. So, where did that come from?

 

[Fire7467]

Didnt realized it but its not working was just manually doing it to show you but it should be there too

 

[kweaver]

It would help me if you gave me an possible input table and the result table you expect. Thanks.