Excel how to incorporate the data segment of a launch for them roughly
Raw data:
The agent for the unit price KSN
The 6285962101 8.8 123
The 6285962102 8.8 123
The 6285962103 8.8 123
The 6285962104 8.8 123
The 69356479 28.8 456
The 69356480 28.8 456
The 69356481 28.8 456
The 69356482 28.8 456
The 6285962105 28.8 123
The 6285962106 28.8 123
The 69356483 8.8 789
The 69356484 8.8 789
The 69356485 8.8 789
The 69356486 8.8 789
The 69356487 8.8 789
The 69356488 8.8 789
The 69356489 8.8 789
The 69356490 8.8 789
The 69356491 8.8 789
The 69356492 8.8 789


After the merger:

The agent for the unit price KSN takes the KSN
The 123 6285962101 6285962104 8.8
The 456 69356479 69356482 28.8
The 123 6285962105 6285962106 28.8
The 789 69356483 69356492 8.8

Troublesome everybody a great god help to write a piece of code, thank you

CodePudding user response:

In Excel?

CodePudding user response:

Is excel the macro function

CodePudding user response:

Essentially a section becomes a tiger balm, what problem to put inside,

CodePudding user response:

This question is not worth to write code, directly use pivot table,

CodePudding user response:

Pivot tried, because some data of more than 15, can only be stored in text form, through out the

CodePudding user response:

reference 4 floor Runnerchin response:

this kind of question is not worth to write code that directly with the pivot table,

Pivot tried, because some data of more than 15, can only be stored in text form, not to come out

CodePudding user response:

Contact the webmaster, go to the VB section, using the code is not simple, 15 is too big,

CodePudding user response:

More than 15 has nothing to do, just show the problem, you set the display mode (cell format, or perspective, secondary personal name section point value on the right side of the triangle, choose value fields - at the bottom of the display mode, digital format)
Choose numerical this format, have to do is adjust the small digital 0

CodePudding user response:

refer to 7th floor Runnerchin response:

, contact the webmaster to VB section, using the code is not simple, 15 is too big,

Moving plates needn't moderators, can't now "move"?

If it's pure digital, more than 15, there is no difficulty,
Even the "text", can also according to the text more size,

CodePudding user response:

CodePudding user response:

's value, the price is the numerical that a few SN obviously just Numbers, in the form of a string to not have to