Home HowTo Blog TalkingData eBook Q&A Download Documentation Talking Data Official Website Official Website
  • SCUDATA
  • RAQSOFT
  • Login Register
    Desktop  •  360 Reference  •  166 Reply  •  0 Follow
    HowTo
    Follow
    Default Hot Nice Preferred Recent reply Post
    excel(115) clipboard(13) split(10) add-in(10) string split(9) group(7) word extraction(5) distinct(3) row-to-column transposition(2) sort(2) column-to-row transposition(2) data concatenation(2) set operation(2) search & selection(1) conditional query(1) topn(1) intersection(1) string generation(1) command line(1) difference(1) text file association(1) more>>> aggregate(1) string handling(1) data search(1)
    «1 ... 6 7 8 9 10 11 12 13 14 15
    • Lina •    Desktop   •    386 View 386 View    •   2024-04-12 09:49:07

      Excel Search for Each Comma-separated Value from Strings 

    • Lina •    Desktop   •    356 View 356 View    •   2024-04-11 10:26:35

      Excel Copy Each Row Multiple Times by the Value of a Specific Column 

    • Lina •    Desktop   •    369 View 369 View    •   2024-04-10 10:11:06

      Excel Get Common Words of Comma-separated Word Strings 

    • Lina •    Desktop   •    368 View 368 View    •   2024-04-09 09:43:17

      Excel Auto-delete Empty Detailed Rows after Grouping 

    • Lina •    Desktop   •    543 View 543 View    •   2024-04-08 10:00:51

      Excel Write All Values of the Non-Grouping Field in One Row 

    • Lina •    Desktop   •    303 View 303 View    •   2024-04-07 13:10:33

      Excel Sort a Certain Column according to the Specific Order of Key Words It Contains 

    • Lina •    Desktop   •    351 View 351 View    •   2024-04-03 10:00:41

      Excel Group Rows and Concatenate Each Value of a Specific Column into a String 

    • Lina •    Desktop   •    295 View 295 View    •   2024-04-02 16:09:58

      Excel Column-to-Row Transposition 

    • blackduckie •    Desktop   •    430 View 430 View    •   2021-07-30 19:05:07

      Column-to-Row Transposition 

    • blackduckie •    Desktop   •    421 View 421 View    •   2021-07-30 18:54:37

      Calculate the Difference of Two White-space-separated Strings 

    • blackduckie •    Desktop   •    380 View 380 View    •   2021-07-30 15:40:55

      Find Corresponding Data in the One Table Using the Other Table 

    • blackduckie •    Desktop   •    365 View 365 View    •   2021-07-30 15:23:03

      Remove Duplicates from Each Numeric String, Sort Digits, and Concatenate Them 

    • blackduckie •    Desktop   •    420 View 420 View    •   2021-07-30 14:54:34

      Find Values Corresponding to Keys Stored in a Specific Cell 

    • blackduckie •    Desktop   •    398 View 398 View    •   2021-07-30 14:38:22

      Sum up Key Value Pairs and Concatenate Results 

    • blackduckie •    Desktop   •    425 View 425 View    •   2021-07-30 11:07:26

      Move Cells Containing Values in the Last Four Columns into Corresponding Rows 

    • blackduckie •    Desktop   •    336 View 336 View    •   2021-07-30 10:47:59

      Group Rows and Concatenate Each Value of a Specific Column into a String 

    • blackduckie •    Desktop   •    365 View 365 View    •   2021-07-30 09:56:59

      List Values in a Specific Column Whose Occurrences Rank in Top 10 

    • blackduckie •    Desktop   •    364 View 364 View    •   2021-07-29 18:26:46

      Concatenate Two Columns and Enter Result to Another Column 

    • blackduckie •    Desktop   •    457 View 457 View    •   2021-07-29 14:41:00

      Insert Values in a Specific Column That Are Substrings of Values of Another Column to the Third Column 

    • blackduckie •    Desktop   •    405 View 405 View    •   2021-07-29 11:43:34

      Sort a Certain Column according to the Specific Order of Key Words It Contains 

    • blackduckie •    Desktop   •    388 View 388 View    •   2021-07-28 18:42:11

      Check Whether Each Value of a Specific Column Contains All Words in a Specified Cell 

    • blackduckie •    Desktop   •    462 View 462 View    •   2021-07-28 18:29:10

      Write All Values of the Non-Grouping Field in One Row 

    • blackduckie •    Desktop   •    361 View 361 View    •   2021-07-28 18:05:14

      Query a Cross Table according to Both Row Value and Column Value 

    • blackduckie •    Desktop   •    363 View 363 View    •   2021-07-28 17:55:08

      Auto-delete Empty Detailed Rows after Grouping 

    • blackduckie •    Desktop   •    426 View 426 View    •   2021-07-28 17:38:23

      Get Common Words of Comma-separated Word Strings 

    «1 ... 6 7 8 9 10 11 12 13 14 15

    Recent hot

    • 2.4 Main line
    • 2.5 Fluctuation amplitude
    • 2.6 Fluctuation frequency
    • 3.1 Anomaly detection and alarm intensity

    New group

    • Application  
    • NOTE  
    • Promote  
    • Guide  
    • YModel  
    • Desktop  
    • eBook  
    • Performance  
    • InSQL  
    • InFiles  
    • InReport  
    • HowTos  
    • json&xml  
    • Excel  
    • text  
    • SQL  
    • Report  
    • DraftBoard  
    • Q&A  
    • TalkingData  
    • News  
    • Download  
    • esProc  

    Contribute open source GitHub

    • 【Solo】 GitHub 上 Star 数最多的 Java 博客
    • 【Sym】 现代化的社区论坛系统
    • 【Pipe】 小而美的博客平台
    • 【Wide】 Golang 黑科技之在线 IDE
    About esProc SPL esProc Statistic
    © 2025 esProc Community Data computing&representation