Change Header Row to First Row from Join output

[ThankForYourHelp]

Hi guys,

I need to change my header row to my first row. this data is from join output, its not the input file. so there is no  First Row Contains Data option for me to choose. see table below:

Table 1:

this is my header ->	Property Number	test_1 - Net Depletable Basis	test_2 - Net Depletable Basis	test_1 - Cost Depletion	test_2 - Cost Depletion
1	202		41996.91		555
2	201	859		429.5

Table 2: 

This should be my header  ->>>>>	->>>>>>	1	2	3	4
1	Property Number	test_1 - Net Depletable Basis	test_2 - Net Depletable Basis	test_1 - Cost Depletion	test_2 - Cost Depletion
2	202		41996.91		555
3	201	859		429.5

[PangHC]

i built a macro for it. but it select all columns and return "FieldX" instead.

demote header to rows 

[DawnDuong · Accepted solution]

hi @ThankForYourHelp 

You can achieve this with with transpose and a few simple downstream basic tool.Something like the attached. However, I'm not entirely use what use case you have for this because the "correct" table you want to achieve looks inefficient if you need to handle it downstreams.

Dawn.