Hi there- I am having trouble moving and rearranging data just from one sheet to another.
I have attached a sample workbook of the data layout that it is currently in (Before) and what I need it to be (After).
I was wondering if anyone could assist me with writing a macro to do this. I also think using Vlookup for Item and Type would be best, no?
Thanks in advance for your help!