Macro for a Transpose

Hi I need a help creating a Macro that will help me transpose a cell with 4 to 6 lines and transpose these lines into separate columns. Example:

John Doe
300 West Way
Los Angeles, CA 90210
[email protected]
(101) 202-3435

John Doe 300 West Way Los Angeles, CA 90210 [email protected] (101) 202-3435


I have approximately 30 to 50,000 cells which contain this data in the same manner. I have attached an example hoping someone can help. I greatly appreciate your time in advance.

try this macro

Please Login or Register  to view this content.

Best Regards
MaczaQ