Lists: Getting Name 1 and Name 2 to appear as separate columns

Hi everyone -

I'm trying to create a list that would show names within a household as separate columns.  Currently, it shows the Household as one row, the A1 account as another and the A2 accounts as another.  Ideally, I would be able to see the A1 account (first name, last name, and ID) in their own columns and then the A2 info in separate columns.  This will eventually be for a Wealth Engine upload, so I need to format it correctly based on their template.

Thanks!