title is bit confusing but I have a data like the below
date,assetname,assetIP 2020/05/05 10:00:00,esprbtrapmgr1,195.187.11.144 2020/05/05 10:00:00,nxc-webap2,10.186.36.196 2020/05/05 10:00:00,eytocesxc7p15,10.16.22.186 2020/05/05 10:00:00,eytocesxc7p15,10.16.22.18 2020/05/05 10:00:00,eytocesxc7p15,10.16.26.98 2020/05/05 10:00:00,aktocesxc16p08,10.16.26.21 2020/05/05 10:00:00,aktocesxc16p08,10.16.56.23
and I want a table like any suggestions ?
assetname| assetIP |assetIP2 |assetIP3 ....
esprbtrapmgr1|195.187.11.144
eytocesxc7p15 |10.16.22.186|10.16.22.18|10.16.26.98|
aktocesxc16p08|10.16.26.21|10.16.56.23
... View more