-
7.4 Split aggregation value and fill them in detail rows
eBook • 0 Reply • 248 View • 2023-11-23 17:10 -
7.3 Fill aggregation value in the first row of the same group of data
eBook • 0 Reply • 204 View • 2023-11-23 17:07 -
-
-
6.13 Find out interval in which a certain condition occurs continuously
eBook • 0 Reply • 205 View • 2023-11-23 17:04 -
6.12 Filter by maximum or minimum value within a group (find out one for each group)
eBook • 0 Reply • 260 View • 2023-11-23 17:04 -
-
-
6.9 Take values of adjacent rows in same group (search & filter within adjacent intervals)
eBook • 0 Reply • 227 View • 2023-11-23 17:02 -
-
-
-
6.5 Search for row number that satisfies the condition
eBook • 0 Reply • 197 View • 2023-11-23 17:00 -
6.4 Search for position of a certain value, take the value by position
eBook • 0 Reply • 209 View • 2023-11-23 16:59 -
-
-
-
5.11 Split multi-Sheet file into multiple files - unfixed number of Sheets
eBook • 0 Reply • 270 View • 2023-11-23 11:47 -
5.10 Split by column - merge duplicate rows after splitting
eBook • 0 Reply • 182 View • 2023-11-23 11:46 -
5.9 Split by column - by column - take column name as Sheet name
eBook • 0 Reply • 274 View • 2023-11-23 11:46 -
5.8 Split by column - by column - take column name as file name
eBook • 0 Reply • 209 View • 2023-11-23 11:45 -
5.7 Format conversion - split tables with primary-sub relationship into cards
eBook • 0 Reply • 225 View • 2023-11-23 11:45 -
5.6 Split by row - split multiple cards to make one card generate one file
eBook • 0 Reply • 213 View • 2023-11-23 11:44 -
-
5.4 Split by row - segment by data (by filtering condition)
eBook • 0 Reply • 227 View • 2023-11-23 11:41 -
5.3 Split by row - group by data - split into multiple files
eBook • 0 Reply • 223 View • 2023-11-23 11:40 -
5.2 Split by row - group by data - split into multiple Sheets
eBook • 0 Reply • 203 View • 2023-11-23 11:40 -
-