A traditional way of shaping data in Excel is by using the VLOOKUP() function.  After identifying the item to look up and the array in which to search for it, a range is identified where the new information can be … Continue reading →