EXCEL: How to pivot data (transform lines into columns & inverse)
Le
claire soc sci
I want to sort my data in Excel according to lines.
However, Excel sorts only on columns.
I used to know a command to pivot the spreadsheet: one keystroke and the
page was inverted, columns became lines and lines became columns.
Absolutely can't find such a command in my current version of Excel 2002.
Please help!
Alternatively, if you know a way to sort data by lines
Thanks
Claire
However, Excel sorts only on columns.
I used to know a command to pivot the spreadsheet: one keystroke and the
page was inverted, columns became lines and lines became columns.
Absolutely can't find such a command in my current version of Excel 2002.
Please help!
Alternatively, if you know a way to sort data by lines
Thanks
Claire
Poser une question
Insert - Function - Transpose ?
You just copy your datas and in Edit/special paste you'll find what you
want. (I don't remember in english...)
Regards.
Gros Minet.
Bye
"claire soc sci" message de news:
Or perhaps : data/sort/ Options clic "from the left to the right".
"Gros Minet"
clients essaient de faire pareil:
http://www.languefrancaise.net/news...;PHPSESSIDcfc21953096fa9f433f8d3c232f73c
Thread-Topic: EXCEL: How to pivot data (transform lines into columns &
inverse)
thread-index: AcYhDogySM3Zlql3RHOEjFd2UkjJOQ= X-WBNR-Posting-Host: 82.123.96.244
% Information related to '82.123.96.0 - 82.123.96.255'
inetnum: 82.123.96.0 - 82.123.96.255
netname: IP2000-ADSL-BAS
descr: BSMSO152 Montsouris Bloc 1
country: FR
admin-c: WITR1-RIPE
tech-c: WITR1-RIPE
status: ASSIGNED PA
remarks: for hacking, spamming or security problems send mail to
remarks: AND
mnt-by: FT-BRX
source: RIPE # Filtered
"claire soc sci" message de news:
"Gros Minet"