In Excel 2007 -

I have data organized in rows under headings (Account, First name, Last
name, Title...) for multiple contacts within each account. I need to move all
contacts for each company into one single row for that company (multiple
contacts for each company in one row ( First name 1, Last name 1...First name
2, Last name 2....) can this be done easily?

This.....

Account First name Last name Title
ABC company Donna Smith Manager
ABC company Karen Jones VP, Media

To this:

Account First name Last name Title First name Last
name Title
ABC company Donna Smith Manager Karen Jones VP