EXCEL: How to pivot data (transform lines into columns & inverse)
7 réponses
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
Cette action est irreversible, confirmez la suppression du commentaire ?
Signaler le commentaire
Veuillez sélectionner un problème
Nudité
Violence
Harcèlement
Fraude
Vente illégale
Discours haineux
Terrorisme
Autre
pascalv
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.
Insert - Function - Transpose ?
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.
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.
Insert - Function - Transpose ?
Gros Minet
Hello !
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" <claire soc a écrit dans le message de news:
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
Hello !
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" <claire soc sci@discussions.microsoft.com> a écrit dans le
message de news: 5F5F9F7F-9AF7-40B9-948A-E2BF54439419@microsoft.com...
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
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" <claire soc a écrit dans le message de news:
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
Gros Minet
Re,
Or perhaps : data/sort/ Options clic "from the left to the right".
"Gros Minet" a écrit dans le message de news:
Hello !
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" <claire soc a écrit dans le message de news:
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
Re,
Or perhaps : data/sort/ Options clic "from the left to the right".
"Gros Minet" <grosminet@libre.gaule> a écrit dans le message de news:
esaOsQRIGHA.3120@TK2MSFTNGP10.phx.gbl...
Hello !
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" <claire soc sci@discussions.microsoft.com> a écrit dans
le message de news: 5F5F9F7F-9AF7-40B9-948A-E2BF54439419@microsoft.com...
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
Or perhaps : data/sort/ Options clic "from the left to the right".
"Gros Minet" a écrit dans le message de news:
Hello !
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" <claire soc a écrit dans le message de news:
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
Clément Marcotte
Depuis que France Télécom a gagné le prix de la carpette anglaise, ses clients essaient de faire pareil:
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" <claire soc a écrit dans le message de news:
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
Depuis que France Télécom a gagné le prix de la carpette anglaise, ses
clients essaient de faire pareil:
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: postmaster@wanadoo.fr AND abuse@wanadoo.fr
mnt-by: FT-BRX
source: RIPE # Filtered
"claire soc sci" <claire soc sci@discussions.microsoft.com> a écrit dans le
message de news: 5F5F9F7F-9AF7-40B9-948A-E2BF54439419@microsoft.com...
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
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" <claire soc a écrit dans le message de news:
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
Clément Marcotte
Franchement, vous me décevez tous les deux.
"Gros Minet" a écrit dans le message de news:
Re,
Or perhaps : data/sort/ Options clic "from the left to the right".
"Gros Minet" a écrit dans le message de news:
Hello !
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" <claire soc a écrit dans le message de news:
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
Franchement, vous me décevez tous les deux.
"Gros Minet" <grosminet@libre.gaule> a écrit dans le message de news:
O9JG4VRIGHA.3944@tk2msftngp13.phx.gbl...
Re,
Or perhaps : data/sort/ Options clic "from the left to the right".
"Gros Minet" <grosminet@libre.gaule> a écrit dans le message de news:
esaOsQRIGHA.3120@TK2MSFTNGP10.phx.gbl...
Hello !
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" <claire soc sci@discussions.microsoft.com> a écrit dans
le message de news: 5F5F9F7F-9AF7-40B9-948A-E2BF54439419@microsoft.com...
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
Or perhaps : data/sort/ Options clic "from the left to the right".
"Gros Minet" a écrit dans le message de news:
Hello !
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" <claire soc a écrit dans le message de news:
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
"claire soc sci" <claire soc a écrit dans le message de news:
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
"claire soc sci" <claire soc sci@discussions.microsoft.com> a écrit dans le
message de news: 5F5F9F7F-9AF7-40B9-948A-E2BF54439419@microsoft.com...
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
"claire soc sci" <claire soc a écrit dans le message de news:
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
Clément Marcotte
Et puis si jamais c'est la faute du site web, cela fait assez longtemps qu'ils savent qu'il y a un problème avec leur interface de broche à foin :joelc @ microsoft.com
(enlever les espaces)
"claire soc sci" <claire soc a écrit dans le message de news:
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
Et puis si jamais c'est la faute du site web, cela fait assez longtemps
qu'ils savent qu'il y a un problème avec leur interface de broche à foin
:joelc @ microsoft.com
(enlever les espaces)
"claire soc sci" <claire soc sci@discussions.microsoft.com> a écrit dans le
message de news: 5F5F9F7F-9AF7-40B9-948A-E2BF54439419@microsoft.com...
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
Et puis si jamais c'est la faute du site web, cela fait assez longtemps qu'ils savent qu'il y a un problème avec leur interface de broche à foin :joelc @ microsoft.com
(enlever les espaces)
"claire soc sci" <claire soc a écrit dans le message de news:
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
