How do you take a list of data and put it in columns?

kristyconforti

New Member
Joined
Dec 20, 2005
Messages
4
Example - I want to make this:

NAME Deduction Amt
John Medical 66.55
John Dental 83.19
John 401K 499.15
John 401KM 99.83
Mike Medical 43.06
Mike Dental 53.83
Mike 401K 129.18
Mike 401KM 64.59

look like this:
Name Medical Dental 401k 401km
John 66.55 83.19 499.15 99.83
Mike 43.06 53.83 129.18 64.59

PLEASE HELP! This will solve a huge problem for me.
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Watch MrExcel Video

Forum statistics

Threads
1,118,823
Messages
5,574,523
Members
412,601
Latest member
TheBeaniacExpress
Top