Excel or Access change some rows to columns
<p>I have some long data I need to convert into a wide fixed width text format.  </p>

<p>I have a large spreadsheet of rows that are duplicated for each person where the only difference, where the person is the same, are two columns.  </p>

<p>I want to remove the duplicates and instead of having multiple rows where the only difference are the columns 'type' and 'process'.  They are all in the same row and repeated 30 times each, some columns would be blank if there are not 30 rows for that person.  I've attached a picture if my explanation makes no sense: <a href="http://i.stack.imgur.com/wg7gr.png" rel="nofollow"><img src="http://i.stack.imgur.com/wg7gr.png" alt="enter image description here"></a></p>

<p>I'm not sure if this can be done in VBA, or python or other language would be better</p>

<p>You can do that using a pivot table:</p>

<ul>
<li>put name then DOB as row labels</li>
<li>put type then process as column labels</li>
<li>put count of process in values</li>
<li>right-click your pivot table, select expand/collapse and expand by process</li>
<li>go to design, report layout, and select tabular layout</li>
<li>right click on totals rows and columns that you do not want and hide them</li>
</ul>

<p>Here's how it looks for me, for a smaller table:</p>

<p><a href="http://i.stack.imgur.com/F3uc5.jpg" rel="nofollow"><img src="http://i.stack.imgur.com/F3uc5.jpg" alt="enter image description here"></a></p>

python excel