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

« 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
RobertT

Offline Offline

Posts: 11646




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

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

It doesn't give me that option.
Logged
4D
Or not 4D that is the question

Offline Offline

Posts: 21797


I can't bear it 🙄




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

Offline Offline

Posts: 12507




« 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

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

OK, will try that.

Thanks
Logged
4D
Or not 4D that is the question

Offline Offline

Posts: 21797


I can't bear it 🙄




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

Offline Offline

Posts: 1515




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

Offline Offline

Posts: 6848





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

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

Offline Offline

Posts: 25436


Absolute Calamity!




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: