The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
I have an Excel with data rowwise. ropund 1000 data
Col1 | Col2 | Col3 | Col4
abc | def | sdd | sdfdf
abc | def | sdd | sdfdf
abc | def | sdd | sdfdf
abc | def | sdd | sdfdf
I want to change it to
Col1 : abc
Col2 : def
Col3 : sdd
Col4 : sdfdf
Col1 : abc
Col2 : def
Col3 : sdd
Col4 : sdfdf
Col1 : abc
Col2 : def
Col3 : sdd
Col4 : sdfdf
Col1 : abc
Col2 : def
Col3 : sdd
Col4 : sdfdf
Any way to convert it automatically ?<
Col1 | Col2 | Col3 | Col4
abc | def | sdd | sdfdf
abc | def | sdd | sdfdf
abc | def | sdd | sdfdf
abc | def | sdd | sdfdf
I want to change it to
Col1 : abc
Col2 : def
Col3 : sdd
Col4 : sdfdf
Col1 : abc
Col2 : def
Col3 : sdd
Col4 : sdfdf
Col1 : abc
Col2 : def
Col3 : sdd
Col4 : sdfdf
Col1 : abc
Col2 : def
Col3 : sdd
Col4 : sdfdf
Any way to convert it automatically ?<
Postet den
Export it to CSV and the run a script on it then import. If you give me a csv copy I'll work on the script.<
Postet den
A function called TRANSPONE or something in MS Excel (TRANSPONERA in Swedish)will do the trick<
Postet den
http://www.techonthenet.com/excel/formulas/transpose.php<