Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Excel transpose problem (https://www.askmehelpdesk.com/showthread.php?t=685614)

  • Jul 22, 2012, 03:11 AM
    amolkhochare
    Excel transpose problem
    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.
  • Jul 22, 2012, 11:48 PM
    JBeaucaire
    '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

  • All times are GMT -7. The time now is 07:26 AM.