-
-
-
-
-
-
pjf • Excel • 1 Reply 748 View • 2021-04-02 08:12:39
Convert one row into multiple rows based on the value
-
-
-
-
-
-
Hoo • Excel • 1 Reply 670 View • 2021-04-02 08:01:34
Get multiple texts after Splitting and concatenating
-
-
-
-
-
Hoo • Excel • 1 Reply 700 View • 2021-04-01 09:38:24
Use interval range to look up association table
-
-
Hoo • Excel • 1 Reply 735 View • 2022-04-20 06:58:09
Use the Associated Table for Interval Association
-
-
Hoo • Excel • 1 Reply 686 View • 2021-04-01 09:30:08
Associating a Single Column with Multiple Columns of Another Table
-
-
-
-
Recent hot
- Open-source SPL: The Sharp Tool for Processing Retrieved Webservice/Restful Data
- 4.14 Merge and de-duplicate by row - duplicate row headers - keep the data that firstly appear
- 4.15 Merge and de-duplicate by row - duplicate row headers - keep non-null data
- 4.16 Merge and de-duplicate by row - duplicate row headers - delete all duplicate data
- 4.17 Merge and de-duplicate by column - duplicate column names - keep data in columns that appear later
- 4.18 Merge by row and column simultaneously - keep data that firstly appear
- 4.19 Format conversion - merge multiple card-style files to form one row-based table
- 4.20 Format conversion - merge multiple primary-sub table files to form two row-based tables
- 4.21 Aggregate files - same rows and columns
- 4.22 Aggregate files - merge by row and column simultaneously - aggregate duplicate records
