Formula to remove data from a query result and create columns with that info seperated

Hi, I need to separate out the pertinent information from a query result into separate columns. First, obviously need a formula, but then want to make it a macro too.

So for the below, I would want the following columns:

1. Column Name = Transaction Document
Value = [blank in this example]

2. Column Name = Item Group
Value = Client 1

3. Column Name = Item Identifier
Value = 010101010101

4. Column Name = Recipient ID
Value = Brent

5. Column Name = Sender ID
Value = State

and so on.. if needed, I an break all of these down like that but think its clear...

Any help with this would be VERY much appreciated! Thanks!!

<TRANSACTION DOCUMENT_VERSION=" " ITEM_GROUP="Client 1" ITEM_IDENTIFIER="010101010101" RECIPIENT_ID="Brent" SENDER_ID="System" STATE="**" SUB_TYPE="*" TRANSACTION_DATE="12/01/2015" TRANSACTION_TYPE="REF"><PARTIES><PARTY_TYPE>1</PARTY_TYPE><PARTY_FIRST_NAME>BRENT</PARTY_FIRST_NAME><PARTY_LAST_NAME>DOE</PARTY_LAST_NAME><PARTY_HOME_PHONE> </PARTY_HOME_PHONE><PARTY_WORK_PHONE>0000000000</PARTY_WORK_PHONE><PARTY_SSN_TIN>123-46-7829</PARTY_SSN_TIN><PARTY_ADDRESS><MAILING_ADDRESS_STREET_NUMBER> </MAILING_ADDRESS_STREET_NUMBER><MAILING_ADDRESS_STREET_NAME>59456 Mailing Add</MAILING_ADDRESS_STREET_NAME><PARTY_MAILING_CITY>Jackson</PARTY_MAILING_CITY><PARTY_MAILING_STATE>Fl</PARTY_MAILING_STATE><PARTY_MAILING_ZIP>123245600</PARTY_MAILING_ZIP></PARTY_ADDRESS><PARTY_ADDRESS><MAILING_ADDRESS_STREET_NUMBER> </MAILING_ADDRESS_STREET_NUMBER><MAILING_ADDRESS_STREET_NAME>12456 Mailing</MAILING_ADDRESS_STREET_NAME><PARTY_MAILING_CITY>Jackson</PARTY_MAILING_CITY><PARTY_MAILING_STATE>Fl</PARTY_MAILING_STATE><PARTY_MAILING_ZIP>1234552</PARTY_MAILING_ZIP></PARTY_ADDRESS></PARTIES><PARTIES><PARTY_TYPE>1</PARTY_TYPE><PARTY_FIRST_NAME>ELLIS</PARTY_FIRST_NAME><PARTY_LAST_NAME>DOE</PARTY_LAST_NAME><PARTY_HOME_PHONE> </PARTY_HOME_PHONE><PARTY_WORK_PHONE>0000000000</PARTY_WORK_PHONE><PARTY_SSN_TIN>123-45-6547</PARTY_SSN_TIN><PARTY_ADDRESS><MAILING_ADDRESS_STREET_NUMBER> </MAILING_ADDRESS_STREET_NUMBER><MAILING_ADDRESS_STREET_NAME>12345 Mailing Address Here</MAILING_ADDRESS_STREET_NAME><PARTY_MAILING_CITY>Jacksonville</PARTY_MAILING_CITY><PARTY_MAILING_STATE>Fl</PARTY_MAILING_STATE><PARTY_MAILING_ZIP>322210000</PARTY_MAILING_ZIP></PARTY_ADDRESS><PARTY_ADDRESS><MAILING_ADDRESS_STREET_NUMBER> </MAILING_ADDRESS_STREET_NUMBER><MAILING_ADDRESS_STREET_NAME>123 Address Here</MAILING_ADDRESS_STREET_NAME><PARTY_MAILING_CITY>Jackson</PARTY_MAILING_CITY><PARTY_MAILING_STATE>Fl</PARTY_MAILING_STATE><PARTY_MAILING_ZIP>12345645</PARTY_MAILING_ZIP></PARTY_ADDRESS></PARTIES><PROPERTIES><PROPERTY_TYPE> </PROPERTY_TYPE><OCCUPANCY_TYPE> </OCCUPANCY_TYPE><PROPERTY_TAX_ID> </PROPERTY_TAX_ID><PROPERTY_ADDRESS><PROPERTY_ADDRESS_STREET_NUM> </PROPERTY_ADDRESS_STREET_NUM><PROPERTY_ADDRESS_STREET_NAME>STREET AND NAME</PROPERTY_ADDRESS_STREET_NAME><PROPERTY_CITY>CITYNAME</PROPERTY_CITY><PROPERTY_STATE>TX</PROPERTY_STATE><PROPERTY_ZIP>XXXXXXX</PROPERTY_ZIP><PROPERTY_COUNTY>EXA</PROPERTY_COUNTY></PROPERTY_ADDRESS></PROPERTIES><LOAN_INFO><LOAN_NUMBER>123456789</LOAN_NUMBER><LOAN_TYPE>VA</LOAN_TYPE><LIEN_POSITION> </LIEN_POSITION><LOAN_AMOUNT>100000</LOAN_AMOUNT><PRINCIPAL_BALANCE>200000</PRINCIPAL_BALANCE><ORIGINATION_DATE>10/01/1900</ORIGINATION_DATE><LOAN_MATURITY_DATE> </LOAN_MATURITY_DATE><LOAN_TERM> </LOAN_TERM><INTEREST_RATE>0.09675</INTEREST_RATE><PAYMENT_DUE_DATE>09/01/1900</PAYMENT_DUE_DATE><CURRENT_PAYMENT_AMOUNT> </CURRENT_PAYMENT_AMOUNT><DEFAULT_DATE> </DEFAULT_DATE><INVESTOR_NAME> </INVESTOR_NAME><CLIENT_INVESTOR_CODE> </CLIENT_INVESTOR_CODE><INVESTOR_LOAN_NUMBER>123456789</INVESTOR_LOAN_NUMBER><MORTGAGE_INSURER_NAME> </MORTGAGE_INSURER_NAME><FORECLOSUE_IN_THE_NAME_OF>PLAINTIFF</FORECLOSUE_IN_THE_NAME_OF><ESCROW_BALANCE> </ESCROW_BALANCE><NTLID>21234545</NTLID><SERVICER_NAME>SERVICERNAMEHERE</SERVICER_NAME><PORTFOLIO_NAME> </PORTFOLIO_NAME><LOAN_FINANCIALS> </LOAN_FINANCIALS></LOAN_INFO><EXTENSIONS><CASE_ID>454545845</CASE_ID><CASE_TYPE>FORECLOSURE</CASE_TYPE><OPEN_DATE>01/01/1900</OPEN_DATE><REFERRAL_STATUS>New Ref</REFERRAL_STATUS><PARENT_NTRID>0</PARENT_NTRID><PROCESS_TYPE>VAOROTHER</PROCESS_TYPE><REFERRAL_CASE_ID>CMPS#</REFERRAL_CASE_ID></EXTENSIONS></TRANSACTION>