Ask Experts Questions for FREE Help !
Ask

Excel transpose problem

Asked Jul 22, 2012, 03:11 AM — 1 Answer
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.

Search this Thread
Share |
1 Answer
JBeaucaire's Avatar
JBeaucaire Posts: 5,377, Reputation: 5036
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.
Columns to Rows - Part 2
Helpful
Not your question? Ask your question View similar questions
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Add your answer here.

Remove Text Formatting
 

Undo
Redo
  
Decrease Size
Increase Size
Bold
Italic
Underline
Align Left
Align Center
Align Right
Ordered List
Unordered List
Decrease Indent
Increase Indent
Insert Email Link
Wrap [QUOTE] tags around selected text
Wrap [CODE] tags around selected text
Wrap [HTML] tags around selected text
Wrap [PHP] tags around selected text
Wrap [YOUTUBE] tags around selected text
Notification Type:



Check out some similar questions!

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

Applicaitons 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? Ie., 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 Spreadsheets questions Search