Forum Discussion
roniexcel2020
Oct 13, 2020Copper Contributor
copying spread words to one column
Hi I teach basic excel and a student of mine asked me a question i did not know the answer to. For some reason he has got an excel sheet with lots of words spread in over columns and rows, some wit...
Riny_van_Eekelen
Oct 13, 2020Platinum Contributor
roniexcel2020 The easiest would be to use PowerQuery, though this goes beyond "basic Excel". Are you familiar with PQ?
Example attached.