Change Header Row to First Row from Join output

Question

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 Numbertest_1 - Net Depletable Basistest_2 - Net Depletable Basistest_1 - Cost Depletiontest_2 - Cost Depletion1202 41996.91 5552201859 429.5

Table 2:

This should be my header  ->>>>>->>>>>>12341Property Numbertest_1 - Net Depletable Basistest_2 - Net Depletable Basistest_1 - Cost Depletiontest_2 - Cost Depletion2202 41996.91 5553201859 429.5

DawnDuong · Accepted Answer

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.