Transposing data from row to columns (not the usual copy past and transpose function)

[casco]

Hi All

I'm having a data set that comprises of a number of entries which is translations in different languages. When the data is exported out of our ERP system it is sorted by language in a column B. I can get the different translations for each product to be beneath each other, for each product code ie Row 2 has English translation, Row t2 have German translation and so or for each product (simple filter to do this). However I would like to end up with the translation for each product in the columns ie product code in column A, English translation in column B, German translation in Column C and so on. Unfortunately the normal transpose functions cant do this so is there an add in or programming I can do to make this happen. We are talking about tens of thousands of lines.

This is how it comes out

Product code	Language	Description
1000-2000	English	Small Clear Insert
1000-2000	German	Kleiner klarer Einsatz

I would like it to be presented as per below

Product Code	Description Language English	Description Language German
1000-2000	Small Clear Insert	Kleiner klarer Einsatz

I'm using Excell 2010

Your help is as always appreciated

Best