title: Access 2010 - imported data from excel - combine two columns into one subform column
body: <p>I'm totally new with Access, so I'm not sure if I'm going about this the right way, but I'm stuck.</p>
  
  <p>I have an excel file with about 5000 records.  Among the data in this file are columns for tracking employment history.  Currently there are two sets of columns, "Job Title 1" &amp; "Employer 1" and "Job Title 2" and "Employer 2"</p>
  
  <p>I'd like to use Access to let users add additional employment records.  Ideally, I'd like to be able to add Job 3, Job 4 and so on, as required.</p>
  
  <p>I've created a form in Access, and it seems to me that a subform is the best way to insert the employment history.  So, I've created a sub form which imports the Job data, but I'm having trouble formatting it.</p>
  
  <p>Right now, I can put Job Title 1 and Job Title 2 into separate columns on the same row, but I'd like to combine them into one 'Job Title' field, and create multiple rows.</p>
  
  <p>If I'm on the right track I could use some help finishing off the subform formatting, or if there's a completely different way to do this I'm open to that too.</p>
  
  <h2>Here's a simplified example record:</h2>
  
  <p>Name: John Smith</p>
  
  <p>Job Title 1: Reporter</p>
  
  <p>Employer 1: Toronto Star</p>
  
  <p>Job Title 2: Columnist</p>
  
  <p>Employer 2: Toronto Sun</p>
  
  <h2>What I want is a table that looks like this, with the option to add additional rows:</h2>
  
  <p>Name: John Smith</p>
  
  <p>Job Title   / Employer</p>
  
  <p>Reporter / Toronto Star</p>
  
  <p>Columnist / Toronto Sun</p>
  
  <p>Thanks in advance for any help, I hope my explanation was clear, but please let me know</p>