<!DOCTYPE EasyDataTransform>
<root>
    <meta>
        <version value="54"/>
        <last_saved_by value="Oryx_Digital_Ltd_using_Easy_Data_Transform_v1_33_0_on_Windows_10_Version_2009_at_2022_09_09_11_41_58"/>
        <locale value="en_GB"/>
        <snap_to_grid value="1"/>
        <notes/>
        <doc_path value="C%3A%5CUsers%5Candy%5CDesktop%5Cdynamic-rename-cols.transform"/>
    </meta>
    <inputs>
        <input pos="-90^74.7" ignored_rows="0" show_meta="0" json_arrays_as_rows="0" delimiter="0" name="Clipboard" pos_v12="-9074.7" watching="0" medium="1" auto_fixed_widths="1" header="1" ignore_empty_cols="0" trim="1" file_type="0" id="323" custom_delimiter="%2A" ignore_repeated_delim="0" text="A%2CA%2CA%2CB%2CA%2CB%2CC%2CA%2CD%0Aa%2Ca%2Ca%2Cb%2Ca%2Cb%2Cc%2Ca%2Cd" meta_text="%24%28CurrentDateTime%29" ignore_empty="1" encoding="Automatic" quote="0" simplify="1"/>
    </inputs>
    <transforms>
        <transform id="325" name="Transpose" pos="149.4^-45" pos_v12="149.4-45">
            <parameters>
                <parameter type="5" name="Header" value="0"/>
            </parameters>
        </transform>
        <transform id="326" name="Remove" pos="388.8^-45" pos_v12="388.8-45">
            <parameters>
                <parameter type="11" name="Columns" value="1"/>
            </parameters>
        </transform>
        <transform id="328" name="Total" pos="867.6^-45" pos_v12="867.6-45">
            <parameters>
                <parameter type="0" name="Column" value="2"/>
                <parameter type="0" name="By" value="1"/>
            </parameters>
        </transform>
        <transform id="329" name="New_Col" pos="628.2^-45" pos_v12="628.2-45">
            <parameters>
                <parameter type="7" name="New_Name" value="N"/>
                <parameter type="7" name="New_Value" value="1"/>
            </parameters>
        </transform>
        <transform id="330" name="Concat" pos="1107^-45" pos_v12="1107-45">
            <parameters>
                <parameter type="1" name="Columns" value="13"/>
                <parameter type="7" name="Delimiter" value="-"/>
                <parameter type="5" name="Keep_Empty" value="0"/>
            </parameters>
        </transform>
        <transform id="331" name="Remove" pos="1346.4^-45" pos_v12="1346.4-45">
            <parameters>
                <parameter type="11" name="Columns" value="4"/>
            </parameters>
        </transform>
        <transform id="332" name="Transpose" pos="1585.8^-45" pos_v12="1585.8-45">
            <parameters>
                <parameter type="5" name="Header" value="0"/>
            </parameters>
        </transform>
        <transform id="333" name="Remove" pos="1825.2^-45" pos_v12="1825.2-45">
            <parameters>
                <parameter type="11" name="Columns" value="2345678910"/>
            </parameters>
        </transform>
        <transform id="334" name="Header" pos="2064.6^-45" pos_v12="2064.6-45">
            <parameters>
                <parameter type="8" name="Num_Rows" value="1"/>
                <parameter type="6" name="Mode" value="Overwrite"/>
                <parameter type="7" name="Delimiter" value=""/>
            </parameters>
        </transform>
        <transform id="335" name="Stack" pos="2304^74.7" pos_v12="230474.7">
            <parameters>
                <parameter type="6" name="Align_Cols" value="Column%20number"/>
                <parameter type="5" name="Only_First_Cols" value="0"/>
                <parameter type="5" name="Add_Separators" value="0"/>
                <parameter type="7" name="User_Defined_Row_Value" value="---"/>
            </parameters>
        </transform>
    </transforms>
    <outputs/>
    <notes>
        <note id="338" comment="Header%20now%20a%20column" pos_v12="388.8-164.7" color="255%1F255%1F255" arrow="3"/>
        <note id="339" comment="New%20column%20names%20computed" pos_v12="1107-164.7" color="255%1F255%1F255" arrow="3"/>
        <note id="340" comment="Converted%20back%20to%20a%20header" pos_v12="2064.6-164.7" color="255%1F255%1F255" arrow="3"/>
        <note id="341" comment="Stack%20as%20new%20header" pos_v12="2304-45" color="255%1F255%1F255" arrow="3"/>
    </notes>
    <connections>
        <connection start_id="323" end_id="325"/>
        <connection start_id="323" end_id="335"/>
        <connection start_id="325" end_id="326"/>
        <connection start_id="326" end_id="329"/>
        <connection start_id="328" end_id="330"/>
        <connection start_id="329" end_id="328"/>
        <connection start_id="330" end_id="331"/>
        <connection start_id="331" end_id="332"/>
        <connection start_id="332" end_id="333"/>
        <connection start_id="333" end_id="334"/>
        <connection start_id="334" end_id="335"/>
    </connections>
    <batch_values/>
    <batch_logging enabled="0" mode="0"/>
</root>
