Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Move data from every other row to columns
Hi - Using Excel 2010.
I have several long lists (each is 600+) of vocabularywords & definitions and need to move the definitions (even-numbered rows)into the next column beside the word it defines. For example: A1 = adjective A2 = a word used to modify a noun or a pronoun A3 = compound A4 = two or more words used together as a single word A5 = interrogative A6 = asks a question A7 = narrative A8 = tells a story Should end up as: A1 = adjective B1 = a word used to modify a noun or a pronoun Row 2 = blank A3 = compound B3 = two or more words used together as a single word Row 4 = blank A5 = interrogative B5 = asks a question Row 6 = blank A7 = narrative B7 = tells a story Paste Special-Transpose doesn't help - it just puts all the data in hundreds of columns left to right. Any advice? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
move two columns of data to four columns | Excel Discussion (Misc queries) | |||
How to move data from rows to columns | Excel Discussion (Misc queries) | |||
match up columns and move data | Excel Programming | |||
move data from rows to columns | Excel Programming | |||
Help in code Steve G wrote to move data from 4 columns to 21 columns | Excel Programming |