Formula to map data with Excel/VBA

[SmallJack]

Hi Gurus,

Would need your kind expertise to help on this request.

Assuming I’ve the following sample data (StudentBook1.xlsx) and wishing if the output data could be formatted using some kind of excel formulas/VBA coding.

For example:
Sheet1 (Sample Data)
Sample of student and book borrowed

Sheet2 (Desired Output)
This is a sample output showing students and book that they've borrowed

Appeciate for any of your help and advice.

Thank you.


- Jack

[PaulSP8]

This will do what you want, I'm trying not to use loops but sometimes they just seem simpler with small data sets.

Please Login or Register  to view this content.

[mjr veverka]

With 'Do ... Loop':

Please Login or Register  to view this content.

[SmallJack]

Hi Guru,

Thanks for your help.

It works as expected.


- Jack

[Pepe Le Mokko]

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.