corruptedlogic
New Member
- Joined
- Mar 8, 2018
- Messages
- 12
Hey there, i need to do what seems easy, but i cannot wrap my head around it. I have a set of data that looks like this:
<tbody>
</tbody>
I need to have some sort of function that will lookup every instance of HH then iterate through and pull every row and enter the data in column format like this:
<tbody>
</tbody>
I have tried index/match to no avail so ended up scrapping that idea. Perhaps VBA is the answer but i have no clue where to start.
The end data set will have 1000+ entries that need to be examined and transposed. Any pointers or ideas greatly appreciated!
Thanks.
HH | Name | Account | Fee | |
1 | Jones | IRA | 0.5% | |
1 | Jones | Individual | 0.8% | |
2 | Smith | Joint | 1.0% | |
2 | Smith | IRA | 0.5% | |
2 | Smith | Trust | 0.9% |
<tbody>
</tbody>
I need to have some sort of function that will lookup every instance of HH then iterate through and pull every row and enter the data in column format like this:
HH | Name | Account1 | Fee1 | Account2 | Fee2 | Account3 | Fee3 |
1 | Jones | IRA | 0.5% | Individual | 0.8% | ||
2 | Smith | Joint | 1.0% | IRA | 0.5% | Trust | 0.9% |
<tbody>
</tbody>
I have tried index/match to no avail so ended up scrapping that idea. Perhaps VBA is the answer but i have no clue where to start.
The end data set will have 1000+ entries that need to be examined and transposed. Any pointers or ideas greatly appreciated!
Thanks.