Pictured above, how can be organized into the following format:

Please teach a master

CodePudding user response:

Can only say that a train of thought,
To sort on the first column, row after row before and after comparison are equal, equal to the number of can together, write down the position, not equal, just kind of classification, the additive amount, fill all the began to count,

CodePudding user response:

I think the sort and merge cells better, will be the last column in the same cell,

CodePudding user response:

"How to organize," is to look at the need (demand), rather than "guess" how should arrange,

CodePudding user response:

If the data in the database, SQL statements can be done,

CodePudding user response:

reference 4 floor vansoft response:

if the data in the database, SQL statements can fix,

Anecdotal hearsay, the data in TXT, CSV, Excel, Access,... , establish a corresponding ODBC and ADO connection, use SQL statements can also be done,