mohammaduir
New member
- Joined
- Oct 6, 2020
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2010
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.
