meaningofexcel
New Member
- Joined
- Jul 25, 2018
- Messages
- 9
I have a table with Names in the first column, one name can have multiple rows.
i.e
ID Column Name | Column Results
1. Name1 Result 1
2. Name2 Result 4
3. Name2 Result 5
4. Name3 Result 1
5. Name4 Result 1
6. Name4 Result 2
and desired result is merging cells B2-B3, B5-B6:
ID Column Name | Column Results
1. Name1 | Result 1
---------------------|----------
2. | Result 4
Name2 |----------
3. | Result 5
---------------------|----------
4. Name3 | Result 1
---------------------|----------
5. | Result 1
Name4 |----------
6. | Result 2
Is that possible using formulas?
i.e
ID Column Name | Column Results
1. Name1 Result 1
2. Name2 Result 4
3. Name2 Result 5
4. Name3 Result 1
5. Name4 Result 1
6. Name4 Result 2
and desired result is merging cells B2-B3, B5-B6:
ID Column Name | Column Results
1. Name1 | Result 1
---------------------|----------
2. | Result 4
Name2 |----------
3. | Result 5
---------------------|----------
4. Name3 | Result 1
---------------------|----------
5. | Result 1
Name4 |----------
6. | Result 2
Is that possible using formulas?