Hello @saintseiyer
I have recently published an UiPath activity pack which includes a data transpose activity. You can easily get your data transposed as you need using this single activity.
https://go.uipath.com/component/data-manipulations#
Make sure to go through the activity guide document on how it can be configured… 
Anil_G
ashokkarale
jinal.shah
Gautham_Pattabiraman
postwick
chandreshsinh.jadeja
vrdabberu
Ajay_Mishra
sven.wullum1
Vyshnavi_Nalumachu