Rearranging data from multiple rows to columns

**tessda** · 09-04-2011, 03:31 PM

Hi guys,

I have datasets converted from PDF to Excel as in the attached workbook. Worksheet "ZOTA" contains an example of the data as converted. I need to rearrange the data in this spreadsheet to provide the results as depicted in sheet "Final". Important to remember is that a "member" may have any number of vehicles registered. Is there an easy way to do this? I have approximately 8000 lines of the data as in "ZOTA" and need a easy way to rearrange this data as soon as possible.

Your assistance will be appreciated.

Regards

Danie

**PaulG2011** · 09-06-2011, 09:36 AM

Hi Danie,

1) In your workbook, make sure that your sheets are named exactly as per the one you attached - i.e. one called "ZOTA" and one called "final".

2) Make sure that your ZOTA sheet data starts in cell A1 and that your first blank row in "final" is row 3.

3) Go to Tools ---> Macro ---> visual basic editor. Paste the following code either into a new module or into the sheet called ZOTA in the VB editor.

Please Login or Register  to view this content.

4) Close the VB editor.

5) Run your code by going to Tools ---> Macro ---> macros....

You should see a macro called process data listed. Select it and click "run". You should see the macro flick to the "final" sheet and start writing data.

6) Let me know how you get on!

Kind regards,

Paul