Microsoft.AspNetCore.Mvc.Localization.LocalizedHtmlStringExcel : RowWise to Landscape

Excel : RowWise to Landscape

Printed from: Snitz™ Forums 2000
URL: https://forum.snitz.com/forumTopic/Posts/67195?pagenum=1
Printed on: 05 November 2025, 12:23

Topic

Author : kolucoms6
Subject : Excel : RowWise to Landscape
Posted : 03 June 2008, 20:39
Message :

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

Replies ...

Reply Author: phy1729
Replied on: 03 June 2008, 23:47
Message:

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

Reply Author: Roger Fredriksson
Replied on: 04 June 2008, 02:31
Message:

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

Reply Author: HuwR
Replied on: 04 June 2008, 03:13
Message:

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