Need help in converting rows to coloumn and attach it to the rows of other table
Hi guys,
I have data of 50X10 coloumn in one excel sheet. I want to convert it to 10X50 coloumn and attach it in front of main table having 10 rows data. Need your help. I have tried tPivot,tnormalize but with no result. Any suggestions would be highly appreciated.
Attached file shows the making of main table with split row and tmap.
