<!DOCTYPE EasyDataTransform>
<root>
    <meta>
        <version value="76"/>
        <last_saved_by value="Trial_user_using_Easy_Data_Transform_v2_4_0_on_Windows_11_Version_2009_x86_64_at_2025_04_16_09_43_19"/>
        <locale value="en_US"/>
        <id value="7f76050f367307060b747a743c0b"/>
        <snap_to_grid value="1"/>
        <notes/>
        <doc_path value="C%3A%5CUsers%5Candy%5CDesktop%5Cexcel-to-xml.transform"/>
        <auto_run_on value="1"/>
    </meta>
    <inputs>
        <input worksheet="Sheet1" pos="-90^-643.5" ignored_rows="0" show_meta="0" json_arrays_as_rows="0" delimiter="0" ignore_excel_hidden_cols="0" schema_in_use="0" name="test.xlsx%5BSheet1%5D" schema_extra_cols="0" pos_v12="-90-643.5" watching="0" medium="0" auto_fixed_widths="1" path="C%3A%5CUsers%5Candy%5CDesktop%5Ctest.xlsx" header="1" schema_missing_cols="0" ignore_empty_cols="0" schema_reorder_cols="0" trim="1" meta_col_name="Meta%20Info" file_type="1" id="0" alias="767%20MX%20Program%20Draft%202025-04-0" custom_delimiter="%2A" ignore_repeated_delim="0" meta_text="%24%28FilePath%29%20%24%28CurrentDateTime%29" ignore_excel_hidden_rows="0" ignore_empty="1" encoding="Automatic" quote="0" simplify="0"/>
    </inputs>
    <transforms>
        <transform id="9" name="Split" pos="388.8^-523.8" pos_v12="388.8-523.8">
            <parameters>
                <parameter type="0" name="Columns" value="1"/>
                <parameter type="6" name="Delimiter_Type" value="Regex%20delimiter"/>
                <parameter type="7" name="Delimiter" value="%5B%5Cr%5Cn%5D%2B"/>
                <parameter type="7" name="Lengths" value="2%2C1%2C%2A"/>
                <parameter type="6" name="Into" value="Rows"/>
                <parameter type="6" name="Order" value="Current"/>
                <parameter type="5" name="Keep_Empty" value="0"/>
                <parameter type="8" name="Min_New_Cols" value="0"/>
                <parameter type="8" name="Max_New_Cols" value="100"/>
            </parameters>
        </transform>
        <transform id="15" name="Remove" pos="149.4^-763.2" pos_v12="149.4-763.2">
            <parameters>
                <parameter type="11" name="Columns" value="12"/>
            </parameters>
        </transform>
        <transform id="17" name="Remove" pos="149.4^-523.8" pos_v12="149.4-523.8">
            <parameters>
                <parameter type="11" name="Columns" value="3"/>
            </parameters>
        </transform>
        <transform id="18" name="Split" pos="628.2^-523.8" pos_v12="628.2-523.8">
            <parameters>
                <parameter type="0" name="Columns" value="1"/>
                <parameter type="6" name="Delimiter_Type" value="Text%20delimiter"/>
                <parameter type="7" name="Delimiter" value="%3A%20"/>
                <parameter type="7" name="Lengths" value="2%2C1%2C%2A"/>
                <parameter type="6" name="Into" value="Columns"/>
                <parameter type="6" name="Order" value="Current"/>
                <parameter type="5" name="Keep_Empty" value="0"/>
                <parameter type="8" name="Min_New_Cols" value="0"/>
                <parameter type="8" name="Max_New_Cols" value="100"/>
            </parameters>
        </transform>
        <transform id="19" name="Remove" pos="867.6^-523.8" pos_v12="867.6-523.8">
            <parameters>
                <parameter type="11" name="Columns" value="23"/>
            </parameters>
        </transform>
        <transform id="20" name="Rename_Cols" pos="1107^-523.8" pos_v12="1107-523.8">
            <parameters>
                <parameter type="13" name="RenameColumns" value="ColumnC.data._typeColumnC.data._value"/>
            </parameters>
        </transform>
        <transform id="22" name="Concat_Rows" pos="1346.4^-523.8" pos_v12="1346.4-523.8">
            <parameters>
                <parameter type="6" name="Mode" value="Fixed"/>
                <parameter type="8" name="Rows" value="4"/>
                <parameter type="6" name="While_Or_Until" value="Until"/>
                <parameter type="6" name="Matches" value="%3D%20%20%20Equal%20to"/>
                <parameter type="7" name="Value" value=""/>
                <parameter type="0" name="Key_Column" value="0"/>
                <parameter type="5" name="Repeat_Key_Column" value="1"/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
                <parameter type="6" name="Concat_Value" value="Omit"/>
            </parameters>
        </transform>
        <transform id="23" name="Join" pos="1825.2^-643.5" pos_v12="1825.2-643.5">
            <parameters>
                <parameter type="6" name="By" value="Row%20number"/>
                <parameter type="0" name="Column_1" value="0"/>
                <parameter type="5" name="Include_Non_Matching_1" value="0"/>
                <parameter type="0" name="Column_2" value="0"/>
                <parameter type="5" name="Include_Non_Matching_2" value="0"/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
                <parameter type="5" name="Detailed_Report" value="0"/>
            </parameters>
        </transform>
        <transform id="24" name="Rename_Cols" pos="1585.8^-523.8" pos_v12="1585.8-523.8">
            <parameters>
                <parameter type="13" name="RenameColumns" value="ColumnC.%21data._typeColumnC.%21data._valueColumnC.%21%21data._typeColumnC.%21%21data._valueColumnC.%21%21%21data._typeColumnC.%21%21%21data._valueColumnC.%21%21%21%21data._typeColumnC.%21%21%21%21data._value"/>
            </parameters>
        </transform>
    </transforms>
    <outputs>
        <output enable_output="1" pos="2064.6^-643.5" delimiter="1" html_encode="1" excel_output="0" multi_file_confirm="1" multi_file_column="0" name="output1.xml" json_manual_col_types="0000000000" write_header_first_append_only="1" bom="1" pos_v12="2064.6-643.5" excel_use_style_template="0" single_or_multi="0" overwrite_sheet="1" path="C%3A%5CUsers%5Candy%5CDownloads%5Coutput1.xml" xml_root="root" remove_empty="1" file_type="5" id="4" custom_delimiter="%2A" alias="output1" write_header="1" excel_manual_col_formats="0000000000" json_types="0" xml_row="entry" encoding="UTF-8" line_endings="0" quote="0"/>
    </outputs>
    <notes/>
    <connections>
        <connection start_id="0" end_id="15"/>
        <connection start_id="0" end_id="17"/>
        <connection start_id="9" end_id="18"/>
        <connection start_id="15" end_id="23"/>
        <connection start_id="17" end_id="9"/>
        <connection start_id="18" end_id="19"/>
        <connection start_id="19" end_id="20"/>
        <connection start_id="20" end_id="22"/>
        <connection start_id="22" end_id="24"/>
        <connection start_id="23" end_id="4"/>
        <connection start_id="24" end_id="23"/>
    </connections>
    <batch_values/>
    <batch_logging enabled="0" mode="0"/>
</root>
