transpose X matching headers X duplicate tables (multiple problems)

NO WAY!

you are AMAZING!

Two Questions:

1. why is I2 "='Original Data'!K1" and the rest countif's?
2. V7 and V8 are getting their values from V1 & V2 from original data. Not sure why but it seems after V6 the data starts getting the values from the beg?

this is insane how good it is.

I just posted another problem on the thread if you want to take a look :D

Also is there a way I can click something and it does it AUTO, since if there are 50 rows and 20 columns it might be hard to drag down 50*20 times perfectly, just as an example