can you do a smaller table with similar examples of the manipulation you want? I don't quite understand what you need.

Should all be possible with just excel using HLOOKUP and VLOOKUP (it can...