Forum Discussion
Help with Word to Excel export
I work on a Mac and don't have access to Power Query (sad to say; I'd love it)...frankly it's still not clear, however, what this is all about. So even if I did have PQ abilities, I'm not sure how I'd help.
I tried, just for the sake of trying, to use Copy and Paste Special, picking the option under Paste Special to "Transpose"--which would turn the entries in rows into entries in columns. It works, but because you don't have one Option A, for example, under the first question, the two lines take two columns, and so on across the Excel template. That might be a partial solution, but it wouldn't just take your Word column and change it into a row in Excel, not without some manual juggling on your part.
The bigger quandary, from my point of view: This really looks like a strange task to even involve Excel. Other than the fact that you've been given an Excel template to fill in, it's not something that really uses Excel for what Excel is good at. All it appears to be doing is taking advantage of cells, cells arrayed in rows and columns. But you know what? Word can do that too, and what you're working with happens to be, coincidentally, "words"! So why not use a word processor?
Fortunately for you, there are other experts here who not only have PQ, but are really good with it, so if there is a solution that fits your parameters, just be patient.