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.