The original data is this:


To make this:


Prepositional procedure that column, line 9, and the columns are respectively synthesize nine cells into a cell, note that because the table, responsible, task allocation, two columns, all of the lines is the same value, namely responsible all line are visus, task allocation is all rows visus2, I need to get this effect


I've used a pivot table, but couldn't do the visus merged into this effect, it will be the whole form of visus merged into one,

CodePudding user response:

The merger involves an inter-bank, may need to VBA, help top!

CodePudding user response:

You mean the need to use the code?

CodePudding user response:

Use VBA

CodePudding user response:

Use VBA can be achieved

CodePudding user response:

Can consider to use VBA to realize the demand

CodePudding user response:

This cannot pass the visual VBA

CodePudding user response:

Use VBA to realize, or use the sort merge manually, basic translation

CodePudding user response:

Necessary toolbox in excel, super merge cells, the selected area all merged into multiple cell in a row, vertical integration, simple and practical

CodePudding user response:

Should need VBA to realize in the end

CodePudding user response:

Use VBA to realize