transpose duplicate rows to columns

Here is one approach:

Please Login or Register  to view this content.

Wow stephen...yours is much fancier than mine...I've never used the scripting dictionary before...

Here's my brute force solution.

I'm not sure what row and column to start from, as I have excel 2003 and couldn't open your example....but they are indicated.

Please Login or Register  to view this content.

looks messy...too many comments...

StephenR, Nomel... thank you so much! So quick answers and your scripts works perfect. I am totally astound!

Compared, I believe StephenR:s script is a bit faster

... anyway, a BIG thanks to both of you!

/J

The first code is much faster but it is not working with my data. something got mixed up.

The second code is working OK, but I prefer that it not delete - overwrite my data.

Thanks to both of you anway.

Here is sample of my data...

* bump *

Hi all,

I face a similar problem as the topic starter, yet somewhat more extensive.
Let me illustrate: I have Excel 2007 and a thirty column lexicon in the following format:

word1 ; word_a ; value 1 ; etc.
word1 ; word_b ; value 2 ; etc.
word2 ; word_c ; value 2 ; etc.
word2 ; word_d ; value 3 ; etc.
word2 ; word_e ; value 4 ; etc.
word3 ; word_f ; value 1 ; etc.

would it somehow be possible to transpose it to:

word1 ; word_a ; value 1 ; etc. for the full row; word_b ; value 2 ; etc. for the full row
word2 ; word_c ; value 2 ; etc ; word_d ; value 3 ; etc. ; word_e ; value 4 ; etc
word3 ; word_f ; value 1 ; etc

I used the provided macro's by StephenR and Nomel. Very helpful, in particular StephenR's one because I don't want it to overwrite my data.

However, the macro gives the solution only for a single adhering column and not my full range of columns. I'm a real novice, does anyone know what to adjust or add to the macro to take into account the entire range of columns and gives me the solution I want?

Hope my explanation is clear. Thanks in advance for your help, appreciate every suggestion.

Best,
Sander

My apologies, noticed that my problem is already solved in this thread:
http://www.excelforum.com/excel-prog...o-columns.html
Figured it could be helpful for future reference.

Thanks for the excellent knowledge base this forum provides, keep up the good work!

Sorry for the inconvenience.

S.

How do you put the rows into separate columns instead of one column separated by commas?

From here you can do text to columns to keep them in the same row but different columns.

Awesome, was looking all over for this solution, thanks! I've never used a script before, but it does work. I assume there's no function/formula to do this instead?

I'm struggling to figure out this same thing. When I looked at the "transpose_duplicates_example2" it showed an example of what I'm looking for, but I still don't understand what I need to do to accomplish it. I'm not sure if I missed something in the thread or not. I hate to open a new thread if not necessary. Thanks for any help you can provide.