Power Query — Pivoting Data
When pivoting data, how do we ensure that the values of several rows remain related when we move them to be in a single row?
(a) They must share the same data type.
(b)They must have a common ID column or attribute column.
(c) We must manually select which cells belong in the row.
(d) We must use a delimiter to make that association.