Problem:
I have multiple fields in Column C that match up to account numbers in Column A. I need the Field Names in Column C to be headers of the top row of this report. The account number should be the first column (YdAcct), then D1_Alias should be Column B, D1_Street should be Column C, and so on. So instead of having row Column A , Rows 2-25 be the same account number , only Column A row 2 should show the account number and Column B should start the field names. From there, the data in Column C should populate the Field Name columns or be left blank if there is no data.
Extra Problem:
These should be all of the column names: RCVR, D1_ALIAS, D1_STREET, D1_CS, D1_ZIP, D1_PHONE, SERVICE_D, ANSWER_DUE_D ,ANSWER_FILE_D, HEARING_D, LIEN_D, SERVICE_TYPE ,D1_CELL ,D2_NAME, EMP_NAME, EMP_STREET ,EMP_CS ,EMP_ZO ,EMP_PHONE, EMP_FAX, EMP_INCOME ,BANK_NAME, BANK_PHONE, BANK_NAME, BANK_PHONE, ADVA_NAME, ADVA_STREET, ADVA_CSZ, ADVA_PHONE, SUIT_AMT, SUIT_DATE ,DOCKET_NO, JDGMNT_DATE ,JDGMNT_AMT ,PREJ_INT, RATES_PRE, RATES_POST, JUDG_PRIN, JDGMNT_BAL, LEGAL_COUNTY, LEGAL_STATE, CRT_TYPE ,JDGMNT_EXP_DATE, PLAN_DATE, PLAN_BAL ,FIRST_DATE ,PAY_AMT ,LAST_DATE
As you can see, each account number has different amounts of columns that are actually able to be populated, making it very difficult to write a VBA that would take the account number in one row and populate the data in the columns.
I am working with nearly 100,000 rows of data so this needs to be an automated fix. Is there anyone who can possibly help me? Could a pivot work for this? I am pulling this data from SQL, in case that helps. Thanks so much in advance!
Example:
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 408"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD="align: right"]89627[/TD]
[TD] NULL[/TD]
[TD]31[/TD]
[/TR]
[TR]
[TD="align: right"]89627 [/TD]
[TD]NULL[/TD]
[TD]OH40[/TD]
[/TR]
[TR]
[TD="align: right"]89627[/TD]
[TD]NULL[/TD]
[TD]NY71[/TD]
[/TR]
[TR]
[TD="align: right"]89627[/TD]
[TD]D1_ALIAS[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]89627[/TD]
[TD]D1_STREET[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]89627[/TD]
[TD]D1_CS[/TD]
[TD]ASHTABULA, OH[/TD]
[/TR]
[TR]
[TD="align: right"]89627[/TD]
[TD]D1_ZIP[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]89627[/TD]
[TD]D1_PHONE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]89627[/TD]
[TD]SERVICE_D[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]89627[/TD]
[TD]ANSWER_DUE_D[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]89627[/TD]
[TD]ANSWER_FILE_D[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]89627[/TD]
[TD]HEARING_D[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]89627[/TD]
[TD]LIEN_D[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]89627[/TD]
[TD]SERVICE_TYPE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]89627[/TD]
[TD]D1_CELL[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]95540[/TD]
[TD]SUIT_AMT[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD="align: right"]95540[/TD]
[TD]SUIT_DATE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]95540[/TD]
[TD]DOCKET_NO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]95540[/TD]
[TD]JDGMNT_DATE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]95540[/TD]
[TD]JDGMNT_AMT[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD="align: right"]95540[/TD]
[TD]PREJ_INT[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD="align: right"]95540[/TD]
[TD]RATES_PRE[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD="align: right"]95540[/TD]
[TD]RATES_POST[/TD]
[TD]0.09[/TD]
[/TR]
[TR]
[TD="align: right"]95540[/TD]
[TD]JUDG_PRIN[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD="align: right"]95540[/TD]
[TD]JDGMNT_BAL[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD="align: right"]95540[/TD]
[TD]LEGAL_COUNTY[/TD]
[TD]Lake[/TD]
[/TR]
[TR]
[TD="align: right"]95540[/TD]
[TD]LEGAL_STATE[/TD]
[TD]IL[/TD]
[/TR]
[TR]
[TD="align: right"]95540[/TD]
[TD]CRT_TYPE[/TD]
[TD]Civil[/TD]
[/TR]
[TR]
[TD="align: right"]95540[/TD]
[TD]JDGMNT_EXP_DATE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]NULL[/TD]
[TD]31[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]NULL[/TD]
[TD]HI1[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]NULL[/TD]
[TD]NY71[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]D1_ALIAS[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]D1_STREET[/TD]
[TD]47-648A Melekula Rd[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]D1_CS[/TD]
[TD]Kaneohe,HI[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]D1_ZIP[/TD]
[TD]96744[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]D1_PHONE[/TD]
[TD]8082398474[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]SERVICE_D[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]ANSWER_DUE_D[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]ANSWER_FILE_D[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]HEARING_D[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]LIEN_D[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]SERVICE_TYPE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]D1_CELL[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]SUIT_AMT[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]SUIT_DATE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]DOCKET_NO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]JDGMNT_DATE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]JDGMNT_AMT[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]PREJ_INT[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]RATES_PRE[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]RATES_POST[/TD]
[TD]0.1[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]JUDG_PRIN[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]JDGMNT_BAL[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]LEGAL_COUNTY[/TD]
[TD]Honolulu[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]LEGAL_STATE[/TD]
[TD]HI[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]CRT_TYPE[/TD]
[TD]DISTRICT COURT[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]JDGMNT_EXP_DATE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]99679[/TD]
[TD]NULL[/TD]
[TD]31[/TD]
[/TR]
[TR]
[TD="align: right"]99679[/TD]
[TD]NULL[/TD]
[TD]HI1[/TD]
[/TR]
[TR]
[TD="align: right"]99679[/TD]
[TD]NULL[/TD]
[TD]NY71[/TD]
[/TR]
[TR]
[TD="align: right"]99679[/TD]
[TD]D1_ALIAS[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]99679[/TD]
[TD]D1_STREET[/TD]
[TD]251 Hakalau Pl[/TD]
[/TR]
[TR]
[TD="align: right"]99679[/TD]
[TD]D1_CS[/TD]
[TD]Honolulu,HI[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I have multiple fields in Column C that match up to account numbers in Column A. I need the Field Names in Column C to be headers of the top row of this report. The account number should be the first column (YdAcct), then D1_Alias should be Column B, D1_Street should be Column C, and so on. So instead of having row Column A , Rows 2-25 be the same account number , only Column A row 2 should show the account number and Column B should start the field names. From there, the data in Column C should populate the Field Name columns or be left blank if there is no data.
Extra Problem:
These should be all of the column names: RCVR, D1_ALIAS, D1_STREET, D1_CS, D1_ZIP, D1_PHONE, SERVICE_D, ANSWER_DUE_D ,ANSWER_FILE_D, HEARING_D, LIEN_D, SERVICE_TYPE ,D1_CELL ,D2_NAME, EMP_NAME, EMP_STREET ,EMP_CS ,EMP_ZO ,EMP_PHONE, EMP_FAX, EMP_INCOME ,BANK_NAME, BANK_PHONE, BANK_NAME, BANK_PHONE, ADVA_NAME, ADVA_STREET, ADVA_CSZ, ADVA_PHONE, SUIT_AMT, SUIT_DATE ,DOCKET_NO, JDGMNT_DATE ,JDGMNT_AMT ,PREJ_INT, RATES_PRE, RATES_POST, JUDG_PRIN, JDGMNT_BAL, LEGAL_COUNTY, LEGAL_STATE, CRT_TYPE ,JDGMNT_EXP_DATE, PLAN_DATE, PLAN_BAL ,FIRST_DATE ,PAY_AMT ,LAST_DATE
As you can see, each account number has different amounts of columns that are actually able to be populated, making it very difficult to write a VBA that would take the account number in one row and populate the data in the columns.
I am working with nearly 100,000 rows of data so this needs to be an automated fix. Is there anyone who can possibly help me? Could a pivot work for this? I am pulling this data from SQL, in case that helps. Thanks so much in advance!
Example:
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 408"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD="align: right"]89627[/TD]
[TD] NULL[/TD]
[TD]31[/TD]
[/TR]
[TR]
[TD="align: right"]89627 [/TD]
[TD]NULL[/TD]
[TD]OH40[/TD]
[/TR]
[TR]
[TD="align: right"]89627[/TD]
[TD]NULL[/TD]
[TD]NY71[/TD]
[/TR]
[TR]
[TD="align: right"]89627[/TD]
[TD]D1_ALIAS[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]89627[/TD]
[TD]D1_STREET[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]89627[/TD]
[TD]D1_CS[/TD]
[TD]ASHTABULA, OH[/TD]
[/TR]
[TR]
[TD="align: right"]89627[/TD]
[TD]D1_ZIP[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]89627[/TD]
[TD]D1_PHONE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]89627[/TD]
[TD]SERVICE_D[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]89627[/TD]
[TD]ANSWER_DUE_D[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]89627[/TD]
[TD]ANSWER_FILE_D[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]89627[/TD]
[TD]HEARING_D[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]89627[/TD]
[TD]LIEN_D[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]89627[/TD]
[TD]SERVICE_TYPE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]89627[/TD]
[TD]D1_CELL[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]95540[/TD]
[TD]SUIT_AMT[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD="align: right"]95540[/TD]
[TD]SUIT_DATE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]95540[/TD]
[TD]DOCKET_NO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]95540[/TD]
[TD]JDGMNT_DATE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]95540[/TD]
[TD]JDGMNT_AMT[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD="align: right"]95540[/TD]
[TD]PREJ_INT[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD="align: right"]95540[/TD]
[TD]RATES_PRE[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD="align: right"]95540[/TD]
[TD]RATES_POST[/TD]
[TD]0.09[/TD]
[/TR]
[TR]
[TD="align: right"]95540[/TD]
[TD]JUDG_PRIN[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD="align: right"]95540[/TD]
[TD]JDGMNT_BAL[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD="align: right"]95540[/TD]
[TD]LEGAL_COUNTY[/TD]
[TD]Lake[/TD]
[/TR]
[TR]
[TD="align: right"]95540[/TD]
[TD]LEGAL_STATE[/TD]
[TD]IL[/TD]
[/TR]
[TR]
[TD="align: right"]95540[/TD]
[TD]CRT_TYPE[/TD]
[TD]Civil[/TD]
[/TR]
[TR]
[TD="align: right"]95540[/TD]
[TD]JDGMNT_EXP_DATE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]NULL[/TD]
[TD]31[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]NULL[/TD]
[TD]HI1[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]NULL[/TD]
[TD]NY71[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]D1_ALIAS[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]D1_STREET[/TD]
[TD]47-648A Melekula Rd[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]D1_CS[/TD]
[TD]Kaneohe,HI[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]D1_ZIP[/TD]
[TD]96744[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]D1_PHONE[/TD]
[TD]8082398474[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]SERVICE_D[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]ANSWER_DUE_D[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]ANSWER_FILE_D[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]HEARING_D[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]LIEN_D[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]SERVICE_TYPE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]D1_CELL[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]SUIT_AMT[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]SUIT_DATE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]DOCKET_NO[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]JDGMNT_DATE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]JDGMNT_AMT[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]PREJ_INT[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]RATES_PRE[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]RATES_POST[/TD]
[TD]0.1[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]JUDG_PRIN[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]JDGMNT_BAL[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]LEGAL_COUNTY[/TD]
[TD]Honolulu[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]LEGAL_STATE[/TD]
[TD]HI[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]CRT_TYPE[/TD]
[TD]DISTRICT COURT[/TD]
[/TR]
[TR]
[TD="align: right"]97157[/TD]
[TD]JDGMNT_EXP_DATE[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]99679[/TD]
[TD]NULL[/TD]
[TD]31[/TD]
[/TR]
[TR]
[TD="align: right"]99679[/TD]
[TD]NULL[/TD]
[TD]HI1[/TD]
[/TR]
[TR]
[TD="align: right"]99679[/TD]
[TD]NULL[/TD]
[TD]NY71[/TD]
[/TR]
[TR]
[TD="align: right"]99679[/TD]
[TD]D1_ALIAS[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]99679[/TD]
[TD]D1_STREET[/TD]
[TD]251 Hakalau Pl[/TD]
[/TR]
[TR]
[TD="align: right"]99679[/TD]
[TD]D1_CS[/TD]
[TD]Honolulu,HI[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
