I think creating more than four contacts could be possible, but before we move further I just need to confirm your desired outcome.

Could you adjust your sample data to contain two tabs. One with the original data (no extra columns) and then a tab with the final results in the format you desire?