esProc Desktop's Blog
Tag

spreadsheets

#spreadsheets

More content

Read more stories on Hashnode

Articles with this tag

#145 — Insert Blank Row when Meeting with Data Change

Feb 17, 20251 min read

Problem description & analysis: Here below is a data table: Task: We want to insert one blank row when the values in two adjacent rows change, the...

#145 — Insert Blank Row when Meeting with Data Change

#144 — Insert Row after Specific Row

Feb 14, 20251 min read

Problem description & analysis: Here below is a data table: Task: Insert one row after the number 100, and fill in a001, a002, … in turn, like...

#144 — Insert Row after Specific Row

#143 — Expand One Row into Multiple Rows after Splitting Text

Feb 12, 20251 min read

Problem description & analysis: The following is a data table, in which columns D and E have multiple lines of text, the number of lines is the same,...

#143 — Expand One Row into Multiple Rows after Splitting Text

#142 — Expand One Row into Multiple Rows Based on Value

Feb 11, 20252 min read

Problem description & analysis: There is a data table, which stores some information of products. The first column is the serial number, and the...

#142 — Expand One Row into Multiple Rows Based on Value

#138 — Convert Certain Columns of the Same Row, as Group Members, to Multiple Rows

Jan 27, 20251 min read

Problem description & analysis: Here below is a data table: Task: Now we want to convert it to a row-based table, like this: Solution: Use SPL XLL...

#138 — Convert Certain Columns of the Same Row, as Group Members, to Multiple Rows

#137 — Re-group or Sort When Filling Grouped Data into Columns

Jan 26, 20251 min read

Problem description & analysis: There is a data table. In this table, the products with the same name may have multiple colors. Task: Convert the...

#137 — Re-group or Sort When Filling Grouped Data into Columns