Move a row in the middle of my data to the Top

[batista_randy]

Hi everyone! I have data that looks like this

Tile Sequence	Column 1	Column 2
1	Country	United States
2	X1	A1
3	X2	A2
4	X3	A3
5	X4	A4
6	Name	John Doe
7	X5	A5
8	X6	A6
9	X7	A7
10	X8	A8
11	X9	A9
12	X10	A10

Id like to move row 6 to the top and make that my row 1. Does anyone know what tool I can use to get this done?

[alexnajm]

Are you trying to cut off the first six rows? If so, you could use a Sample to Skip First N Rows (N = 6) and use a Dynamic Rename after to Take Field Names from first row of data

[alexnajm]

Because of the first column, I assume this is not an Excel Input but if it was, you could Start Data on Line 6 instead of Line 1

[CoG · Accepted solution]

If you are not trying to remove data, then you can use the Formula Tool to re-index the data and Sort afterwards.

[Raj]

do you want to make them column header or just the first row
if first row @CoG has given a good solution
if you want to make header just add dynamic rename tool after it.