Reorganizing from Row to Column

[cank3r]

Hello everyone, I've been searching for an answer but haven't had any luck. Hope you guys can help.

I have this(but bigger):


Title 1

Data 1
Title 2
Data 2


I want it to look like this:


Title 1 Title 2
Data 1 Data 2

 

[Roderick_E]

XLSuperTool has this "Single Column Parser" rodericke.com/xlsuper

 

[inactiveuserps07]

@cank3r, does your actual data alternate exactly as Title, Data, Title, Data ... (i.e., one title followed by one item of data, no blanks in between)?

If not, is there an exactly regular pattern (e.g., title, four items of data, title, four items of data, title ...)?

Or do the number of items of data under each title vary?