Help with Transform Range

[beezer2484]

I have attached an example of what I need to have happen. Okay so here is my problem.
I have a list with a hundred thousand plus rows in it, they include name, address, city/state/zip and a numeric value all listed in a single column, problem is, I need them to be in separate columns labeled name, address, city/state/zip and value. I know how to transform a range but the real problem is that some of the contacts have a contact name. So instead of having 4 cells of info, some have 5. I do not know how to get excel to overcome this. One helpful bit of info though, is that every contacts info ends with a numeric value. Thanks for your time

[xladept]

Hi Beezer,

Try this:

Please Login or Register  to view this content.

Directions for running the routine(s) just supplied

Copy the code to the clipboard

Open your Workbook

Press ALT + F11 to open the Visual Basic Editor.

Select “Module” from the Insert menu

Type "Option Explicit" then paste the code into the white space on the right

With the cursor between Sub and End Sub press F5 (F8 to Single Step)

OR

Press ALT + Q to close the code window.

Press ALT + F8 then double click on the macro name

You're welcome!