Hi I finding a formula where the range and value in a same row I need to transpose it with the value I want. I tried pivot to split the range and value fail it's not giving me the result. Below is the sample how the data been arranged:
1
Name
Alex
Team
Soldier
Team Leader
Sam
2
Name
Sunny
Team
Warriors
Team Leader
Sharon
There is 2 set of data how to get the name and team name only from the data set as transpose. What excel formula I can use for this?
Hi I finding a formula where the range and value in a same row I need to transpose it with the value I want. I tried pivot to split the range and value fail it's not giving me the result. Below is the sample how the data been arranged:
1
Name
Alex
Team
Soldier
Team Leader
Sam
2
Name
Sunny
Team
Warriors
Team Leader
Sharon
There is 2 set of data how to get the name and team name only from the data set as transpose. What excel formula I can use for this?
If your data is arranged as row then use Hlookup and if in column then use vlookup.
In both the cases you will be looking 'name' and 'team'