• •      •    25 View    •   2024-08-01 06:32:18

## Group columns of an Excel table and perform aggregation

• •      •    27 View    •   2024-07-31 09:02:28

## Replace duplicate items with the specified text

• •      •    38 View    •   2024-07-27 00:53:55

## Match the first part of the cell value

• •      •    41 View    •   2024-07-26 00:34:40

## Get a random row from each group

• •      •    139 View    •   2024-07-25 05:12:04

## Remove duplicates and compute intersection

• •      •    44 View    •   2024-07-23 08:21:54

## Find the difference between contents of two cells

• •      •    41 View    •   2024-07-22 10:08:11

## Find the first cell value meeting the specified condition

• •      •    51 View    •   2024-07-19 08:26:32

## Write the first lines of multiple csv files to Excel

• •      •    44 View    •   2024-07-18 10:05:11

## Align rows of data to a specified column

• •      •    38 View    •   2024-07-18 02:13:01

## Group an Excel table and store as multiple files according to part of value of the specified cell

• •      •    42 View    •   2024-07-16 08:16:37

## Combine two tables with different column headers

• •      •    46 View    •   2024-07-16 08:13:58

## Group and summarize a table where every N rows consist of a range by column

• •      •    52 View    •   2024-07-11 08:25:39

## Write continuous numbers in a string of numbers as intervals

• •      •    55 View    •   2024-07-09 13:08:28

## Repeat value of each cell N times according to value of the neighboring cell

• •      •    157 View    •   2024-07-08 03:02:42

## Expand multi-row text in a cell to multiple cells

• •      •    76 View    •   2024-07-05 06:04:23

## Concatenate column values and perform grouping & aggregation

• •      •    80 View    •   2024-07-04 13:37:43

## Summarize data every two columns under each category

• •      •    79 View    •   2024-07-04 09:40:21

## Group rows and concatenate cell values

• •      •    77 View    •   2024-07-01 03:22:29

## List positions of each character

• •      •    85 View    •   2024-07-01 01:56:51

## Split & group text and perform distinct on each group

• •      •    95 View    •   2024-06-26 02:21:11

## Split each cell value and expand it according to the specified rule

• •      •    82 View    •   2024-06-24 13:21:00

## Import a txt file where separator is missing in a column to Excel

• •      •    96 View    •   2024-06-24 13:15:45

## In Excel, re-arrange a sequence N times randomly

• •      •    94 View    •   2024-06-24 09:00:03

## In Excel, parse hexadecimal numbers and make queries

• •      •    97 View    •   2024-06-24 08:59:47