-
6.9 Take values of adjacent rows in same group (search & filter within adjacent intervals)
eBook • 0 Reply • 502 View • 2023-11-23 17:02 -
-
-
-
6.5 Search for row number that satisfies the condition
eBook • 0 Reply • 446 View • 2023-11-23 17:00 -
6.4 Search for position of a certain value, take the value by position
eBook • 0 Reply • 486 View • 2023-11-23 16:59 -
-
-
-
5.11 Split multi-Sheet file into multiple files - unfixed number of Sheets
eBook • 0 Reply • 539 View • 2023-11-23 11:47 -
5.10 Split by column - merge duplicate rows after splitting
eBook • 0 Reply • 454 View • 2023-11-23 11:46 -
5.9 Split by column - by column - take column name as Sheet name
eBook • 0 Reply • 536 View • 2023-11-23 11:46 -
5.8 Split by column - by column - take column name as file name
eBook • 0 Reply • 467 View • 2023-11-23 11:45 -
5.7 Format conversion - split tables with primary-sub relationship into cards
eBook • 0 Reply • 501 View • 2023-11-23 11:45 -
5.6 Split by row - split multiple cards to make one card generate one file
eBook • 0 Reply • 432 View • 2023-11-23 11:44 -
-
5.4 Split by row - segment by data (by filtering condition)
eBook • 0 Reply • 495 View • 2023-11-23 11:41 -
5.3 Split by row - group by data - split into multiple files
eBook • 0 Reply • 498 View • 2023-11-23 11:40 -
5.2 Split by row - group by data - split into multiple Sheets
eBook • 0 Reply • 464 View • 2023-11-23 11:40 -
-
-
-
-
4.23 Aggregate files - aggregate by cell positions - unfixed number of files
eBook • 0 Reply • 500 View • 2023-11-23 11:38 -
4.22 Aggregate files - merge by row and column simultaneously - aggregate duplicate records
eBook • 0 Reply • 489 View • 2023-11-23 11:37 -
-
4.20 Format conversion - merge multiple primary-sub table files to form two row-based tables
eBook • 0 Reply • 477 View • 2023-11-23 11:36 -
4.19 Format conversion - merge multiple card-style files to form one row-based table
eBook • 0 Reply • 526 View • 2023-11-23 11:36 -
4.18 Merge by row and column simultaneously - keep data that firstly appear
eBook • 0 Reply • 454 View • 2023-11-23 11:35 -
4.17 Merge and de-duplicate by column - duplicate column names - keep data in columns that appear later
eBook • 0 Reply • 453 View • 2023-11-23 11:34