資源描述:
《把excel里的一列數(shù)據(jù)快速轉(zhuǎn)成多列數(shù)據(jù)》由會員上傳分享,免費(fèi)在線閱讀,更多相關(guān)內(nèi)容在工程資料-天天文庫。
1、把Excel里的一列數(shù)據(jù)快速轉(zhuǎn)成多列數(shù)據(jù)在Excel中,我們也經(jīng)常碰到要將表格中一列的數(shù)據(jù)快速轉(zhuǎn)換成多列的數(shù)據(jù),怎么辦呢?下面筆者以自己的一個親身體會舉例說明。筆者在日常工作之余喜歡讀一點(diǎn)英文新聞,在閱讀過程中把一些生詞積累起來,建立了一個英語生詞表,如下圖:詞匯現(xiàn)在已經(jīng)累積到了1291個,見下圖:he"governingforthepeople","Nomattertheinterestsofthemasses"conceptunderstandingisnotinplace.Thespecificworktreatswith
2、thedeployment,afewleadingcadrescomplainthatworkistoocomplicated,toomuchresponsibility,thepressureistoolarge,toomuchemphasisonthedifficultyofthework.Forexample,noncoalmine為了記憶單詞方便,筆者想把“單詞”這一列單獨(dú)拿出來,單詞的順序不變,做成一個5列的單詞記憶表。由1列變成5列,到底怎么做比較好呢?如果5個單詞一組進(jìn)行復(fù)制粘貼,1291個單詞,那要反復(fù)做259次
3、,這是很費(fèi)時費(fèi)力的,筆者又另外想了不少別的辦法,比如用公式、函數(shù)等,都不能如意。后來用Excel的數(shù)據(jù)篩選法,則豁然開朗了。首先,把“單詞”這一列復(fù)制粘貼到一個新表中:he"governingforthepeople","Nomattertheinterestsofthemasses"conceptunderstandingisnotinplace.Thespecificworktreatswiththedeployment,afewleadingcadrescomplainthatworkistoocomplicated,to
4、omuchresponsibility,thepressureistoolarge,toomuchemphasisonthedifficultyofthework.Forexample,noncoalmine然后,在第一列前插入一新列:he"governingforthepeople","Nomattertheinterestsofthemasses"conceptunderstandingisnotinplace.Thespecificworktreatswiththedeployment,afewleadingcadresc
5、omplainthatworkistoocomplicated,toomuchresponsibility,thepressureistoolarge,toomuchemphasisonthedifficultyofthework.Forexample,noncoalmine在第1列的第2行開始,依次往下輸入“1”、“2”、“3”、“4”、“5”:he"governingforthepeople","Nomattertheinterestsofthemasses"conceptunderstandingisnotinplace.
6、Thespecificworktreatswiththedeployment,afewleadingcadrescomplainthatworkistoocomplicated,toomuchresponsibility,thepressureistoolarge,toomuchemphasisonthedifficultyofthework.Forexample,noncoalmine選擇這五格:將鼠標(biāo)移到所選區(qū)域右下角,鼠村由空心十字變成黑十字,按住鼠標(biāo)不放,往下拉至第1291行,再按住CTRL鍵不放,先放開鼠標(biāo),再放開CT
7、RL鍵,效果如下圖:he"governingforthepeople","Nomattertheinterestsofthemasses"conceptunderstandingisnotinplace.Thespecificworktreatswiththedeployment,afewleadingcadrescomplainthatworkistoocomplicated,toomuchresponsibility,thepressureistoolarge,toomuchemphasisonthedifficultyof
8、thework.Forexample,noncoalmine選擇表格數(shù)據(jù)區(qū)域:he"governingforthepeople","Nomattertheinterestsofthemasses"conceptunderstandingisnotinplace.