Hi,
Please see screenshot below.
This shows an example of my dataset, and the layout how I would like it to be transformed...
Ideally, I would like to accomplish this with the use of a formula... But I feel like maybe the only way to do it, is VBA ?
I should be able to do it via VBA, but since I'm not the one that will be using the data - and they're not very good with Excel - I'd like to rule out the possibility of doing it with VBA and try to accomplish this with a formula first.
Please take a look and let me know.
I've also attached the workbook.
Thank you very much.
Dataset Example.xlsx