vba script to manipulate fields

[jet]

Hi all,

I have a hopefully easy question.....

I'm working on manipulating a huge file (36,000 some rows, 30 or so
columns). Basically I have information in horizontal form and I need
it to be vertical. I have an email address repeated in multiple rows
and then an associated question and answer with each email.

I want to convert this so I have a column for email, and a column for
each question. I've been working through the file and copying the
data and transposing it to where it needs to be. This is taking
forever. I've done some VBA programming for mapping software, but
don't know any of the objects or libraries to use for this task.

Does anyone have any suggestions? Or have any script samples that
would do this, or could be easily manipulated? Thanks!

Here is an example of my data:
-----------------------------------------------------------
email question answer
email question2 answer
email question3 answer
email2 question answer
email2 question2 answer
email2 question3 answer
etc.........

Here is what I want it to be:

 

[George Nicholson]

I doubt that the solution to your problem is this simple, but if your
answers are (or could be) expressed as numerical values:

Create a Pivot table. Address as row field, Question as column field, Answer
as Data field

Set the FieldSettings property of Answer to Max