Forum Discussion
List formatting help needed
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 |
Let's say your list is in A1:A300.
In (for example) C2, enter the formula
=WRAPROWS(TOCOL(A1:A300, 3), 2)
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.
Are A3, A6, etc. really blank, or do they contain a space or a - ?
