I want to know if there is a way we can treat a pivot block as a table, so that I can link Table A to this pivot block. Then in Table A, I would like to have a lookup column where it can pull in data from fields within the pivot block.

Any advise would be greatly appreciated