I’m probably going to do the one in front of me by hand rather than waiting for a response, but for future reference, I’m wondering if anyone knows a quick way to reorient a table that I created in Word.
What happened is that I made a table (6x18 grid) of names listed in alphabetical order read from left to right. What I just got back was a request to have the names read from top to bottom instead. So:
Adams, John Edward, Michael Lawrence, Timothy
Paine, Jack Smith, Larry Williams, Angela
needs to become:
Adams, John Lawrence, Timothy Smith, Larry
Edward, Michael Pain, Jack Williams, Angela
Thanks, Marcus (and ouryL)…I figured that was something Excel could handle. I tried it per your instructions, and it worked perfectly. I wasn’t aware of the transpose command before.
For future reference, if you want a list of names or whaever to read down 1 column, then down a second column, etc., then use columns, NOT a table. That makes it very easy to insert new entries w/o having to manually move stragglers from one column to another.
For data that must read left to right row by row you’re stuck w/a table & all the hassle for insertions & deletions.
The best way to handle changes in that case is to move the data to excel, paste it into a single column, add/delete as needed, resort, then paste the resulting single column back into Word in place of the old table. Finally, use the text-to-table feature to make a 2, 3, or 4 column table breaking on hard Returns.
Yes, that’s a lot of work. Plan ahead and resist formatting updateable data to read rowwise whenever possible.
