Group by column and transpose rows as columns

[cartoondoor]

I would like to Group by column and transpose rows as columns. Some users will have 4 columns, others will have up to 20.

WHAT I HAVE:
UserID Plan StartDate CancelDate
1 A 2019-05-24 2019-06-20
1 B 2019-06-20 0000-00-00
2 A 2019-12-19 0000-00-00
2 B 2020-01-30 0000-00-00
3 C 2019-03-06 0000-00-00
3 C 2019-03-06 2019-11-28

WHAT I WANT:
UserID Plan StartDate CancelDate Plan StartDate CancelDate
1 A 2019-05-24 2019-06-20 B 2019-06-20 0000-00-00
2 A 2019-12-19 0000-00-00 B 2020-01-30 0000-00-00
3 C 2019-03-06 0000-00-00 C 2019-03-06 2019-11-28

[Limor_OP]

Hi cartoondoor ,
Please see attached.

Columns F&L are helpers for the 2 grey tables retrieving the user ID# (1,2,3).

The 1st table searches for the first duplicated number and returning data accordingly with the formula in G3:

=INDEX(A$1:A$8,MOD(SMALL(IF($F$3:$F$8<>"",$F$3:$F$8*1000+ROW(A$3:A$8)),ROWS(E$3:E3)),1000))


The 2nd table searches for the second duplicated number and returning data accordingly with the formula in M3:
=INDEX(A$1:A$8,MOD(SMALL(IF($L$3:$L$8<>"",$L$3:$L$8*1000+ROW(A$3:A$8)),ROWS(E$3:E3)),1000))

[cartoondoor]

Thanks, Belinda Best solution I've seen yet.

[Limor_OP]

You're welcome.

If your problem is solved, please go to Thread Tools and select Mark This Thread Solved