customer address in different format

Dear friends here i have attached my document.in that first sheet data I'm taking from my system.i want to convert that data as my second sheet.
first sheet appearing customer address in different columns in one row.....i need that all the data in different rows in second sheet.if u check my sample sheet u can get clear idea about my requirement,i need macro to do this work.
If i overwrite first sheet data & run that macro it's should give answer in second sheet.like my sample sheet..pls do it for me it's very big help for me.thanks in advance.....

johncena,

With your raw data in worksheet Sheet1.


A new worksheet Results will be created with the new data format.


Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

1. Copy the below code, by highlighting the code and pressing the keys CTRL + C
2. Open your workbook
3. Press the keys ALT + F11 to open the Visual Basic Editor
4. Press the keys ALT + I to activate the Insert menu
5. Press M to insert a Standard Module
6. Where the cursor is flashing, paste the code by pressing the keys CTRL + V
7. Press the keys ALT + Q to exit the Editor, and return to Excel
8. To run the macro from Excel, open the workbook, and press ALT + F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

Please Login or Register  to view this content.

Then run the ReorgData macro.