Move information from one column (automatically) to another

I have a row of names, with numerical data in 10 ajoining rows (name in row A, with numerical date in rows B-K).  I want to automatically move these entries, from rows A-K to matching names in row M along with the corresponding numerical data.  There are single entry names in Row A, with numerous corresponding names in Row M.  Very time consuming to individually copy and past. 

Appreciate any help you can provide.

rows, columns ?

are you sure you have your definition of rows and columns correct ?

Rows are horizontal, columns are verticle..

best way to get an answer to this is to post an example sheet.. something like:

- I have this data, and I need this output.

Vishesh's picture

Rows, Columns

Seems Excel's Vlookup should be able to solve your problem.