mohammaduir
New Member
- Joined
- Oct 6, 2020
- Messages
- 2
- Office Version
- 2010
- Platform
- Windows
I want to marge the same data from Column A and remain in the same previous Column.
Then every data in Column B converts to one separate Column (Many data in this Column are common), and data of Column C (for every raw) comes to below of new related Column.
It should be noted that the total number of data is very large (more than 100,000 rows)
For example:
I want it to look like this
thanx a lot.
Then every data in Column B converts to one separate Column (Many data in this Column are common), and data of Column C (for every raw) comes to below of new related Column.
It should be noted that the total number of data is very large (more than 100,000 rows)
For example:
Column A (Name) | Column B (box) | Column C (number) |
Aaa | box1 | 2 |
Aaa | box5 | 5 |
Aaa | box6 | 9 |
Bbb | box3 | 8 |
Bbb | box6 | 1 |
Ccc | box1 | 3 |
Ccc | box3 | 5 |
Ccc | box5 | 4 |
Ccc | box10 | 1 |
I want it to look like this
Column A (Name) | Column B (box1) | Column C (box3) | Column D (box5) | Column E (box6) | Column F (box10) |
Aaa | 2 | 5 | 9 | ||
Bbb | 8 | 1 | |||
Ccc | 3 | 5 | 4 | 1 |
thanx a lot.