Combine rows with similar values in one column.

[sgtpepper]

Hi!

I just made an illustration of what I want to achieve:
Attachment 131624

I have these huge lists of data I want to process, but there are multiple instances of the same values in column A that I want to combine
into one instance, please see the attached picture and you will understand.

If anyone can help I am forever grateful!

EDIT: Attachment doesnt seem to work, I put up a mirror of the file here: http://files.psfix.com/excellist.jpg

[Haseeb Avarakkan]

That is exactly Pivot Table do. See this link or Google it,

http://www.addictivetips.com/windows...-pivot-tables/