0

I have a df that looks like

ObjColA   ObjColB
2021-10-13   ABC
2021-10-13   DEF
2021-10-13   XYZ
2021-10-14   ABC
2021-10-14   PQR
2021-10-14   DEF
2021-10-14   XYZ

And I like to turn into a pivot-like diff such that values of ObjColA turn as headers and the rows for them become the ObjColB values corresponding to it.

2021-10-13   2021-10-14
    ABC      ABC
    DEF      PQR
    XYZ      DEF
             XYZ

I understand pivot and pivot table need aggregation method; can you advise how i can achieve this

asimo
  • 2,340
  • 11
  • 29

0 Answers0