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 Truly the end times are upon us!We're gonna win the league. |