I have been entering data from surveys into an Excel spread sheet.
Each respondent may have up to twelve types of problems that they will
have written something about. I have created a separate column for
each row.This is what it looks like (if you get my drift).


-------- ------- ----------------- -----------------------
|Id No: |Name: |Problem 1(Engine)|Problem 2(Transmission)|
-------- ------- ----------------- -----------------------
|1000 |John |Too noisy |Gears hard to change |
-------- ------- ----------------- -----------------------

(with 12 columns for the problems)
(and 200 rows for the names - so far)

But now the client wants each problem to be listed in separate rows
not columns. With the repondents name on each row if there is more
than one problem. This is what it should look like.
--------- -------- -------------- --------------------
|Id No: |Name: |Problem |Verbatim |
--------- -------- -------------- --------------------
|1000 |John |Engine |Too noisy |
--------- -------- -------------- --------------------
|1000 |John |Transimission |Gears hard to change|
--------- -------- -------------- --------------------
(etc up to 12 problems and the verbatim).

I have already entered the data for over 200 surveys. Is there an easy
way to automatically transform the data from the first format into the
second format.

I will be eternally grateful to anyone who can answer this problem.
(Assuming there is an answer).

Thank you,
Harry