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!
Excel Help Example.jpg