Dear Expert,
I am transposing date into one row which are in horizantal format and against some code. That code are multiple and date are variouse

If code will same and date are different, all date should be merge in one row against one code.

e.g.
Material code Date
AC77746 25.06.2012
AC77746 09.07.2012
AC77746 09.07.2012
AC77746 09.07.2012

I want to transpose like this

AC77746 25.06.2012 25.06.2012 09.07.2012 09.07.2012 09.07.2012
AC77746 09.07.2012
AC77746 09.07.2012
AC77746 09.07.2012

Please provide solution.

'COLUMNS TO ROWS
Here's a macro for merging columns of data to one row matching for column A. There's a sample workbook too you could drop your data into and test it out.


Columns to Rows - Part 2 (https://sites.google.com/a/madrocketscientist.com/jerrybeaucaires-excelassistant/text-functions/column-sets-to-rows)