I need some help reordering data that I'm cutting-and-pasting into Excel. The data takes the form of a long list of news articles (100+). For each article I have the headline, publisher's name, time/date of publication/words/language, and a snippet of text. When pasted in, the data appears as shown in the first of the two screenshots below. What I want to do is convert this data so it appears in the second of the two screenshots, with headline, publisher's name, time/date of publication/words/language, and the snippet of texts each in their own column. Is there a quick-and-easy way of doing this? I'm having to do a lot of cut-and-pasting which is very time-consuming and not viable...
Grab A.JPG
To this
Grab B.JPG
Bookmarks