Excel : RowWise to Landscape - Snitz™ Forums 2000

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.

Excel : RowWise to Landscape - Posted 03 Jun 2008 20:39 (1116 Views)

kolucoms6

Average Member

Posts: 845

845

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 ?<

Posted 03 Jun 2008 23:47

phy1729

Average Member

Posts: 589

589

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.<

Last edited by phy1729 on 03 June 2008, 23:47

Posted 04 Jun 2008 02:31

Roger Fredriksson

Average Member

Posts: 556

556

A function called TRANSPONE or something in MS Excel (TRANSPONERA in Swedish)will do the trick<

rf/www.avgifter.com

Posted 04 Jun 2008 03:13

HuwR

Forum Admin

Posts: 20611

20611

http://www.techonthenet.com/excel/formulas/transpose.php<