Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
move two columns of data to four columns PB Excel Discussion (Misc queries) 1 February 24th 10 12:54 AM
How to move data from rows to columns How to move data from rows to columns Excel Discussion (Misc queries) 6 October 13th 09 10:16 AM
match up columns and move data ngg Excel Programming 8 September 11th 08 07:42 PM
move data from rows to columns DME[_2_] Excel Programming 0 July 23rd 08 05:47 PM
Help in code Steve G wrote to move data from 4 columns to 21 columns Steve G Excel Programming 9 August 2nd 07 02:43 PM


All times are GMT +1. The time now is 06:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"