esProc Desktop's Blog
Tag

programming languages

#programming-languages

More content

Read more stories on Hashnode

Articles with this tag

Complement a certain average value to ensure that the total sum remains unchanged — From SQL to SPL #3

Feb 21, 20252 min read

Problem description & analysis: An invoice table in the SQL Server database has one amount for each project, and each project in the project table has...

Complement a certain average value to ensure that the total sum remains unchanged — From SQL to SPL #3

#50 - Group And Summarize Rows And Add Different Words After Different Counts

Aug 23, 20242 min read

Problem description & analysis: An Excel table has two...

#50 - Group And Summarize Rows And Add Different Words After Different Counts

#47 - Sort An EXCEL Table According To Custom Segments

Aug 19, 20243 min read

Problem description & analysis: An Excel table has three...

#47 - Sort An EXCEL Table According To Custom Segments

Expand Multi-Row Text in A Cell to Multiple Cells

Jul 11, 20242 min read

Problem description & analysis: In the following table, column A is the category, and column B includes one or multiple lines of text where the line...

Expand Multi-Row Text in A Cell to Multiple Cells

Group Rows and Concatenate Cell Values

Jul 9, 20241 min read

Problem description & analysis: Here is a categorized detail table: AB1NameName 22Unique 1ex 13Unique 1ex 24Unique 1ex 35Unique 2ext 16Unique 2ext...

Group Rows and Concatenate Cell Values

In Excel, Search A Target Value And Hide Columns To Its Right

Jun 25, 20242 min read

Problem description & analysis: The following Excel table has several columns of...

In Excel, Search A Target Value And Hide Columns To Its Right