I currently have a spreadsheet that I've imported a string of text copied out of an xps document. When I pasted it, all the data flowed on a single row. So the spreadsheet currently looks like this:
A B C D E F G H I J K L M N O P Q R S T U V W X
1358 MICHAEL HAMMOND 214 761 0 0 4 1710 JENNIFER STEPHENS 1 16 0 0 0 1820 LA-VICE GOODWIN 3 12 0 0 0
My example shows A-X, but the actual data goes all the way through OQ (maybe further with future imports).
The way I want the data to be display is like this:
A B C D E F G H
1358 MICHAEL HAMMOND 214 761 0 0 4
1710 JENNIFER STEPHENS 1 16 0 0 0
1820 LA-VICE GOODWIN 3 12 0 0 0
Is there a formula or macro that could do this?
Bookmarks