My question is similar to this post (How to pivot a table in excel from long to wide) except that I don’t know how many columns to be add. In other words, one unique person can have more than one rows but I don’t know how many rows could there be (this is dynamic that cannot be predetermined). It would be very helpful if someone could show me how to set up the DAX code or get the Power Query set up.