Thetownend.com

80% => The Nevillew General Discussion Forum => Topic started by: Flashheart on Monday, December 2, 2019, 13:36:15



Title: An excel question
Post by: 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?


Title: Re: An excel question
Post by: RobertT 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?


Title: Re: An excel question
Post by: Flashheart on Monday, December 2, 2019, 15:42:21
It doesn't give me that option.


Title: Re: An excel question
Post by: 4D 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"


Title: Re: An excel question
Post by: jayohaitchenn 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/


Title: Re: An excel question
Post by: Flashheart on Monday, December 2, 2019, 16:20:10
OK, will try that.

Thanks


Title: Re: An excel question
Post by: 4D on Monday, December 2, 2019, 16:22:20
I answered a question correctly?  :o
We're gonna win the league.


Title: Re: An excel question
Post by: STFC_Manc 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


Title: Re: An excel question
Post by: Ginginho on Monday, December 2, 2019, 19:47:49
Text to columns as STFC_Manc says should do the trick


Title: Re: An excel question
Post by: pauld on Monday, December 2, 2019, 20:38:12
I answered a question correctly?  :o
We're gonna win the league.
Truly the end times are upon us!