Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Community Discussions (All other subjects)
 Excel : RowWise to Landscape		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

kolucoms6
Average Member

845 Posts
Posted - 03 June 2008 :  20:39:19  Show Profile  Reply with Quote
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 ?<

phy1729
Average Member

USA
589 Posts
Posted - 03 June 2008 :  23:47:48  Show Profile  Reply with Quote
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.<
Edited by - phy1729 on 03 June 2008 23:47:59
Go to Top of Page

Roger Fredriksson
Average Member

Sweden
556 Posts
Posted - 04 June 2008 :  02:31:47  Show Profile  Visit Roger Fredriksson's Homepage  Reply with Quote
A function called TRANSPONE or something in MS Excel (TRANSPONERA in Swedish)will do the trick<
rf/www.avgifter.com
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 04 June 2008 :  03:13:09  Show Profile  Visit HuwR's Homepage  Reply with Quote
http://www.techonthenet.com/excel/formulas/transpose.php<
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.07 seconds. Powered By: Snitz Forums 2000 Version 3.4.07