Ask Experts Questions for FREE Help !
Ask
    amolkhochare's Avatar
    amolkhochare Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Jul 22, 2012, 03:11 AM
    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.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Jul 22, 2012, 11:48 PM
    '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.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

I am having a problem with practice problem number one in Office Machines with excel [ 3 Answers ]

Applications 6th edition. The book says 3, 360 and I got 528. What am I overlooking"

Excel - transpose date number sequence [ 5 Answers ]

I have a number sequence that is back to front & want to represent this in the standard European format e.g.. 2009-08-24 should be 24/08/2009 There are several thousand date records to change How do I do this?

20 digit problem in excel [ 1 Answers ]

I can not write 20 digit number in a cell of excel 2007.please guide

Transpose rows into columns in a excel spreadsheet [ 3 Answers ]

Can anyone help 1) how to transpose the data in rows into columns and columns into rows in a Excel spread sheet? 2) how to change the numerical order of data in rows/ columns in a Excel spread sheet? i.e.. from the first row to last row and last row to first row ? Thank "U'

MS Excel default settings problem [ 0 Answers ]

Suddenly on my MS Excel, EVERY previously saved file I have opened has 4 of the columns, BM through BQ with the text in white, so I can't read it. Of course, I can manually switch it back to black, but what caused this? The file dates still have their old original saved dates, so it must be a...

View more questions Search