Pages: [1]   Go Down
Print
Author Topic: An excel question  (Read 318 times)
Flashheart


+63/-10093
Offline Offline

Posts: 27473


FUCK YEAH!



« on: Monday, December 2, 2019, 13:36:15 »

There's probably an easy answer to this that I've missed, but...

I often have information (articles) written in word documents that I need to transfer to excel. The information needs to be added from left to right in separate cells. The articles are a fixed format so there's a fixed number of headers and paragraphs with the corresponding number of cells in excel. 

When I copy and paste, excel separates paragraphs and puts them into separate cells, which is exactly what I want, except... It only copies them doing down the page row by row, but I need it to paste across the page.

I've been copying and pasting one by one, but there must be an easier solution. Right?
Logged

I like it firm and fruity.
RobertT


+59/-30
Offline Offline

Posts: 7249




Ignore
« Reply #1 on: Monday, December 2, 2019, 15:37:39 »

If you are simply asking it to paste from vertical to horizontal, then Paste Special, click Transpose?
Logged
Flashheart


+63/-10093
Offline Offline

Posts: 27473


FUCK YEAH!



« Reply #2 on: Monday, December 2, 2019, 15:42:21 »

It doesn't give me that option.
Logged

I like it firm and fruity.
4D


+102/-96
Online Online

Posts: 12966


I am real




Ignore
« Reply #3 on: Monday, December 2, 2019, 16:07:34 »

I think the only way to do it is copy it across to a spare excel page, then from that data copy to where you want it in excel and paste special ticking "transpose"
Logged
jayohaitchenn
Wielder of the BANHAMMER


+62/-90
Offline Offline

Posts: 11000




« Reply #4 on: Monday, December 2, 2019, 16:12:26 »

Yep, as 4D says. Paste the data into excel as it comes and then transpose to a new sheet after:

https://www.techrepublic.com/blog/microsoft-office/transpose-excel-data-from-rows-to-columns-or-vice-versa/
Logged
Flashheart


+63/-10093
Offline Offline

Posts: 27473


FUCK YEAH!



« Reply #5 on: Monday, December 2, 2019, 16:20:10 »

OK, will try that.

Thanks
Logged

I like it firm and fruity.
4D


+102/-96
Online Online

Posts: 12966


I am real




Ignore
« Reply #6 on: Monday, December 2, 2019, 16:22:20 »

I answered a question correctly?  Shocked
We're gonna win the league.
Logged
STFC_Manc


+2/-0
Offline Offline

Posts: 1004




Ignore
« Reply #7 on: Monday, December 2, 2019, 19:20:10 »

I might have misunderstood but I would copy all the information into Excel.  Then use the text to columns function under data, then fixed width to separate the row into the right columns
Logged
Ginginho


+29/-7
Offline Offline

Posts: 6249





Ignore
« Reply #8 on: Monday, December 2, 2019, 19:47:49 »

Text to columns as STFC_Manc says should do the trick
Logged
pauld


+149/-132
Online Online

Posts: 20744





Ignore
« Reply #9 on: Monday, December 2, 2019, 20:38:12 »

I answered a question correctly?  Shocked
We're gonna win the league.
Truly the end times are upon us!
Logged
Pages: [1]   Go Up
Print
Jump to: