| || |
Rearranging of data in Excel sheet
I have around 10 sheets in an excel sheet and the data is in horizontal format ,I want data to be display in vertical fashion .
Dataname(column name) xyx
datatatype(column name) uuuiui
The data of all ten sheets should display in a in single sheet as showed in the above example.
Can Any one help me out in finding the solution.
Re: Rearranging of data in Excel sheet
Are you using DataTables or Excel Sheets using Excel COM APIs?