Transform a table: pivot vs transpose & repeated cells in rows

[KLolli]

Hello everyone,

I have a table with thousands of dates and I want to transpose it basically, in a way that will avoid having thousand of columns but only the amount linked to the max number of dates associated with a name.

I have table in this format: and I would like to transform it like this:
Name Date Name Date 1 Date 2 Date 3 ... Date n
A 12-02-19 A 12-02-19
B 14-03-20 B 14-03-20
C 22-06-19 C 22-06-19 23-08-20
C 23-08-20 D 01-02-19
D 01-02-19 E 03-05-19 22-07-20 15-04-21
E 03-05-19
E 22-07-20
E 15-04-21

Many thanks for your time and help.

KL.

 

[KLolli]

Hello everyone,

I have a table with thousands of dates and I want to transpose it basically, in a way that will avoid having thousand of columns but only the amount linked to the max number of dates associated with a name.

I have table in this format: and I would like to transform it like this:
Name Date Name Date 1 Date 2 Date 3 ... Date n
A 12-02-19 A 12-02-19
B 14-03-20 B 14-03-20
C 22-06-19 C 22-06-19 23-08-20
C 23-08-20 D 01-02-19
D 01-02-19 E 03-05-19 22-07-20 15-04-21
E 03-05-19
E 22-07-20
E 15-04-21

Many thanks for your time and help.

KL.

Apologies, the formatting changed, please see a picture below.