List formatting help needed

[AndriaG]

I've never posted her before so please forgive me if this question is formatted confusingly. 

To keep it simple, I have a list of books with author names that I'd like to format in excel. I started with Raw data and pasted it into Excel. There's over 100 entries and I'm sure excel has a way to do this quickly but I can't figure out how. Any help would be greatly appreciated. 

Currently, it is formatted as such (plain text all in one row):

Book Title 1

Author 1

Book Title 2

Author 2

I am attempting to format it like this:

Title	Author
Book Title 1	Author 1
Book Title 2	Author 2

[#2]

@AndriaG 

Let's say your list is in A1:A300.

In (for example) C2, enter the formula

=WRAPROWS(TOCOL(A1:A300, 3), 2)

[#3]

@HansVogelaar 

I'm not sure if it didn't work or if I did it wrong. My list is in Column A and spans from Row 1 to Row 554.

The pattern in column A is as follows: Title A (A1), Author A (A2), blank (A3), Title B (A4), Author B (A5), blank (A6)... 

It started as plain text like the below and I pasted right into excel:

Title

Author

-

Title

Author

-

etc.

[#4]

@AndriaG 

Are A3, A6, etc. really blank, or do they contain a space or a - ?

[#5]

They are blank

[#6]

@AndriaG 

For what it's worth, here is the workbook I used to test. Does it provide a clue?

[#7]

Turns out there were spaces, I should've double checked! I found and replaced to remove all the spaces and the formula worked, thank you so much!! ❤️