ashleyuk1984
10-15-2018, 02:44 PM
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.
https://images2.imgbox.com/cf/a8/IYuD66Ek_o.png (http://imgbox.com/IYuD66Ek)
Please take a look and let me know.
I've also attached the workbook.
Thank you very much.
23033
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.
https://images2.imgbox.com/cf/a8/IYuD66Ek_o.png (http://imgbox.com/IYuD66Ek)
Please take a look and let me know.
I've also attached the workbook.
Thank you very much.
23033