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
    «1 ... 5 6 7 8 9 10 11 12 13 14 ... 15»
    • jinxing •    Desktop   •    234 View 234 View    •   2024-08-27 16:25:35

      Combine cell values of every 3 rows under each column into one cell 

    • jinxing •    Desktop   •    339 View 339 View    •   2024-08-26 14:10:54

      Get desired data every N rows and combine them into one row 

    • jinxing •    Desktop   •    281 View 281 View    •   2024-08-23 15:27:01

      Get the last row of each group 

    • jinxing •    Desktop   •    263 View 263 View    •   2024-08-22 16:06:59

      Get rankings of Excel rows in each group while retaining the existing order 

    • jinxing •    Desktop   •    225 View 225 View    •   2024-09-19 18:57:24

      Group and Summarize rows and add different words after different counts 

    • jinxing •    Desktop   •    233 View 233 View    •   2024-08-20 15:03:12

      Group an EXCEL table and concatenate values of rows meeting the specified condition 

    • jinxing •    Desktop   •    215 View 215 View    •   2024-08-19 14:03:32

      In an Excel table, find rows corresponding to the 1st and the last non-empty cells in each column 

    • jinxing •    Desktop   •    227 View 227 View    •   2024-08-16 15:29:21

      Sort an EXCEL table according to custom segments 

    • jinxing •    Desktop   •    193 View 193 View    •   2024-08-15 15:52:42

      Find the category meeting the specified condition 

    • jinxing •    Desktop   •    177 View 177 View    •   2024-08-14 15:36:47

      Copy each row N times (N is the cell value of the specified column) 

    • jinxing •    Desktop   •    334 View 334 View    •   2024-08-09 15:40:14

      Group rows and combine non-null values in each of non-grouping columns 

    • jinxing •    Desktop   •    267 View 267 View    •   2024-08-08 14:21:58

      Find difference between two strings 

    • jinxing •    Desktop   •    229 View 229 View    •   2024-08-07 18:09:52

      Skip empty cells to sort members 

    • jinxing •    Desktop   •    233 View 233 View    •   2024-08-06 16:04:13

      Group and summarize rows while retaining columns whose values are unchanged 

    • jinxing •    Desktop   •    230 View 230 View    •   2024-08-05 16:47:19

      Group and summarize a tree structure table 

    • jinxing •    Desktop   •    190 View 190 View    •   2024-08-05 09:25:46

      Define a dynamic range of columns and perform aggregation 

    • jinxing •    Desktop   •    271 View 271 View    •   2024-08-01 14:32:18

      Group columns of an Excel table and perform aggregation 

    • jinxing •    Desktop   •    231 View 231 View    •   2024-07-31 17:02:28

      Replace duplicate items with the specified text 

    • jinxing •    Desktop   •    191 View 191 View    •   2024-07-27 08:53:55

      Match the first part of the cell value 

    • jinxing •    Desktop   •    248 View 248 View    •   2024-07-26 08:34:40

      Get a random row from each group 

    • jinxing •    Desktop   •    358 View 358 View    •   2024-07-25 13:12:04

      Remove duplicates and compute intersection 

    • jinxing •    Desktop   •    162 View 162 View    •   2024-07-23 16:21:54

      Find the difference between contents of two cells 

    • jinxing •    Desktop   •    202 View 202 View    •   2024-07-22 18:08:11

      Find the first cell value meeting the specified condition 

    • jinxing •    Desktop   •    169 View 169 View    •   2024-07-19 16:26:32

      Write the first lines of multiple csv files to Excel 

    • jinxing •    Desktop   •    192 View 192 View    •   2024-07-18 18:05:11

      Align rows of data to a specified column 

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

    Recent hot

    • A Field Guide to Querying and Report Computations with SPL - 8 Multilevel JSON computations
    • A Field Guide to Querying and Report Computations with SPL - 9 Post-grouping set operations

    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