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

Online Online

Posts: 28771


FUCK YEAH!



« on: Monday, December 2, 2019, 14: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

Offline Offline

Posts: 7664




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

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

Online Online

Posts: 28771


FUCK YEAH!



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

It doesn't give me that option.
Logged

I like it firm and fruity.
4D

Online Online

Posts: 14127


I am real




Ignore
« Reply #3 on: Monday, December 2, 2019, 17: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

Offline Offline

Posts: 11173




« Reply #4 on: Monday, December 2, 2019, 17: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

Online Online

Posts: 28771


FUCK YEAH!



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

OK, will try that.

Thanks
Logged

I like it firm and fruity.
4D

Online Online

Posts: 14127


I am real




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

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

Offline Offline

Posts: 1058




Ignore
« Reply #7 on: Monday, December 2, 2019, 20: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

Offline Offline

Posts: 6364





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

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

Offline Offline

Posts: 22622





Ignore
« Reply #9 on: Monday, December 2, 2019, 21: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: