Organizing Information Using Excel Macros (or any other solution)
 

Hi,

I'm trying to organize information taken from a website and put onto Excel.
The information currently looks like this with everything in the same column.
There are random spaces in between each section of the outline.

1.1 Title
Text Text Text Text Text

Text Text Text Text Text

What I want is

COLUMN 1 COLUMN 2
1.1 Title Text Text Text Text

I don't want extraneous spaces, and was hoping to do this in an automated
fashion; not cutting and pasting. One problem is that I don't know how to
write a macros because although the websites are uniform in structure, once
shown in Excel, they sometimes occupy different cells when compared to one
another.

Thanks for your help.