fahadmalik09
New Member
- Joined
- Jun 1, 2014
- Messages
- 26
Hey Forum,
<tbody>
</tbody>
The above data has 3 as well as 2 values
i need to transpose Name Mobile Email where some email has no data(blank column)
Some has duplicate Mobile number like in above its Mobile3
As soon as i remove duplicate, it also remove empty column between 2 data
I want to make it like this below
<tbody>
</tbody>
If this can be done, i can delete Mobile 3 duplicate contact afterward
Note: Few column has email and few don't have.
I tried concatenate and added all the values, then used comma to separate values and then text to column. But i am doing manually. i dont know how this can be done in 6000+ column.
Help me guys. Thanks in advance
Best Regards
Name1 |
Email1 |
Mobile1 |
Name 2 |
Mobile 2 |
Name 3 |
Email 3 |
Mobile 3 |
Mobile3 |
<tbody>
</tbody>
The above data has 3 as well as 2 values
i need to transpose Name Mobile Email where some email has no data(blank column)
Some has duplicate Mobile number like in above its Mobile3
As soon as i remove duplicate, it also remove empty column between 2 data
I want to make it like this below
Name1 | Email1 | Mobile1 | |
Name2 | Mobile2 | ||
Name3 | Email3 | Mobile3 | Mobile3 |
Name4 | Email4 | Mobile4 |
<tbody>
</tbody>
If this can be done, i can delete Mobile 3 duplicate contact afterward
Note: Few column has email and few don't have.
I tried concatenate and added all the values, then used comma to separate values and then text to column. But i am doing manually. i dont know how this can be done in 6000+ column.
Help me guys. Thanks in advance
Best Regards