how can I transform the data from A to B by using excel or python?

A

```
Column A     Column B      Column C       Column D        Column E
Jack          Micheal      16/02/2021     medicine A     medicine B

```

B

```
Column A      Column B          Column C
Jack          16/02/2021       medicine A
Jack          16/02/2021       medicine B
Micheal       16/02/2021       medicine A
Micheal       16/02/2021       medicine B

```