Home HowTo Blog TalkingData eBook Q&A Download Documentation Talking Data Official Website Official Website
  • SCUDATA
  • RAQSOFT
  • Login Register
    eBook  •  874 Reference  •  100 Reply  •  0 Follow
    RaqKnowledge
    Follow
    Default Hot Nice Preferred Recent reply Post
    desktop and excel data processing cases(180)
    «1 ... 24 25 26 27 28 29 30 31 32 33 ... 35»
    • mars •    eBook   •    505 View 505 View    •   2023-11-23 11:45:51

      5.8 Split by column - by column - take column name as file name 

    • mars •    eBook   •    547 View 547 View    •   2023-11-23 11:45:19

      5.7 Format conversion - split tables with primary-sub relationship into cards 

    • mars •    eBook   •    471 View 471 View    •   2023-11-23 11:44:56

      5.6 Split by row - split multiple cards to make one card generate one file 

    • mars •    eBook   •    512 View 512 View    •   2023-11-23 11:43:46

      5.5 Split by row - generate one card per row 

    • mars •    eBook   •    553 View 553 View    •   2023-11-23 11:41:03

      5.4 Split by row - segment by data (by filtering condition) 

    • mars •    eBook   •    534 View 534 View    •   2023-11-23 11:40:32

      5.3 Split by row - group by data - split into multiple files 

    • mars •    eBook   •    506 View 506 View    •   2023-11-23 11:40:05

      5.2 Split by row - group by data - split into multiple Sheets 

    • mars •    eBook   •    572 View 572 View    •   2023-11-23 11:39:42

      5.1 Split by row - by number of rows 

    • mars •    eBook   •    588 View 588 View    •   2023-11-23 11:39:16

      4.26 Aggregate files - insert aggregation sheet 

    • mars •    eBook   •    468 View 468 View    •   2023-11-23 11:38:51

      4.25 Aggregate files - cumulate and aggregate 

    • mars •    eBook   •    618 View 618 View    •   2023-11-23 11:38:28

      4.24 Aggregate files - append and aggregate 

    • mars •    eBook   •    581 View 581 View    •   2023-11-23 11:38:07

      4.23 Aggregate files - aggregate by cell positions - unfixed number of files 

    • mars •    eBook   •    540 View 540 View    •   2023-11-23 11:37:35

      4.22 Aggregate files - merge by row and column simultaneously - aggregate duplicate records 

    • mars •    eBook   •    563 View 563 View    •   2023-11-23 11:37:13

      4.21 Aggregate files - same rows and columns 

    • mars •    eBook   •    534 View 534 View    •   2023-11-23 11:36:50

      4.20 Format conversion - merge multiple primary-sub table files to form two row-based tables 

    • mars •    eBook   •    603 View 603 View    •   2023-11-23 11:36:04

      4.19 Format conversion - merge multiple card-style files to form one row-based table 

    • mars •    eBook   •    517 View 517 View    •   2023-11-23 11:35:29

      4.18 Merge by row and column simultaneously - keep data that firstly appear 

    • mars •    eBook   •    499 View 499 View    •   2023-11-23 11:34:58

      4.17 Merge and de-duplicate by column - duplicate column names - keep data in columns that appear later 

    • mars •    eBook   •    569 View 569 View    •   2023-11-23 11:34:36

      4.16 Merge and de-duplicate by row - duplicate row headers - delete all duplicate data 

    • mars •    eBook   •    555 View 555 View    •   2023-11-23 11:34:10

      4.15 Merge and de-duplicate by row - duplicate row headers - keep non-null data 

    • mars •    eBook   •    545 View 545 View    •   2023-11-23 11:33:34

      4.14 Merge and de-duplicate by row - duplicate row headers - keep the data that firstly appear 

    • mars •    eBook   •    543 View 543 View    •   2023-11-23 11:33:10

      4.13 Merge and de-duplicate by row - duplicate whole row of data 

    • mars •    eBook   •    553 View 553 View    •   2023-11-23 11:32:39

      4.12 Merge by column - one to many - leave subsequent rows empty 

    • mars •    eBook   •    467 View 467 View    •   2023-11-23 11:32:00

      4.11 Merge by column - one to many - copy data 

    • mars •    eBook   •    520 View 520 View    •   2023-11-23 11:31:36

      4.10 Merge by column - convert file names to column names 

    «1 ... 24 25 26 27 28 29 30 31 32 33 ... 35»

    Tips

    • ✨ 欢迎使用 Sym 来搭建自己的社区!

    Recent hot

    • I Break Down a 100-Line SQL Script That No One Dares to Touch into 7 Steps
    • No More 4-Level Nested SQL: Get a Stock’s Consecutive Up Days Right in Just 5 Steps
    • SQLazy: Find Strings with 5 or More Consecutive Alphabetical Letters
    • Your AI SQL Tool Doesn’t Have an “Undo Logic” Button – That’s the Real Problem
    • Text2SQL Practice: what happens if you ask AI to write a few dozen lines of SQL?
    • Trae + SQLazy: A Practical Guide to Writing Complex SQL

    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
    © 2026 esProc Community Data computing&representation