Santosh080
Board Regular
- Joined
- Jul 15, 2016
- Messages
- 77
- Office Version
- 2021
- Platform
- Windows
Hello Friends
Please help me so that i can do my job quickly in my office. I have an excel file with data like below.
A B C D E
<tbody>
</tbody>
Now i need the above data in the following format,
I want to put "Type" value like 111 or 222 etc. in a cell and the in below "Position" table all data dragged from above table. Can it possible? please help. I do not have any VBA knowledge but i can use formulas like vlookup.
<tbody>
</tbody>
Please help me so that i can do my job quickly in my office. I have an excel file with data like below.
A B C D E
Type | Name | Phone | Position | Cost |
111 | AAA | 9214 | R | 100 |
111 | ALD | 4532 | R | 250 |
111 | NVK | 4271 | F | 300 |
222 | LFO | 6534 | F | 500 |
222 | PGV | 2872 | R | 100 |
222 | FOR | 7575 | R | 600 |
333 | FLP | 2727 | F | 750 |
333 | BVH | 2278 | F | 100 |
333 | DGY | 8372 | R | 900 |
<tbody>
</tbody>
Now i need the above data in the following format,
I want to put "Type" value like 111 or 222 etc. in a cell and the in below "Position" table all data dragged from above table. Can it possible? please help. I do not have any VBA knowledge but i can use formulas like vlookup.
<tbody> </tbody>
<tbody> </tbody> | ||||||||||||||||||||||
<tbody>
</tbody>
Last edited: