Excel example Posted byadmin good programming – check not foundvlookup – https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1 pivot table – not sure 隔行取数