How to transpose duplicate rows to columns

[triade]

Hi!

As an Excel newby, I need your help.

I would like to transpose duplicate rows to columns. I have tried multiple options from this website and others, but they don't remove the transponed rows.

Example (also in Excel sheet):
number1; 30
number1; 40
number2; 40
number2; 40
number2; 50
number3; 80
number3; 50

Can this be transposed to:

number1; 30; 40
number2; 40; 40; 50
number3; 80; 50

Thanks a lot in advance.

[xladept]

The last date entry is an issue but, for the rest - try this:

Please Login or Register  to view this content.

[triade]

Works amazing for my dummy file!

But for my real file, I would like to use the VBA for 1580 rows and this doesn't work.
I think the problems is in the T_Line, could you help me with that?

Exit Sub
T_Line: Q(s, c + 1) = P(r, 2): Q(s, c + 2) = P(r, 3)
Q(s, c + 3) = P(r, 4): Q(s, c + 4) = P(r, 5): Q(s, c + 5) = P(r, 6)
c = c + 5: Return
End Sub

[jindon]

Try

Please Login or Register  to view this content.

[triade]

Thanks Jindon! Unfortunatly your VBA doesn't remove the former duplicate rows.

[jindon]

Missed one line
Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[xladept]

The problem could be here:

Please Login or Register  to view this content.

Because, I'm only allowing enough room for seven header sets (actually 8).

Try:

Please Login or Register  to view this content.

or, if you know how many rows can have the same number - put that in place of the red.


And - Thanks for the rep!