Is there a function that exists where for each change in name, a transpose is made?
For example, for the Subtotal function, you can perform a sum for each name change. Instead of doing a sum, can we do a transpose?
Similar to the Subtotal function where for each change in name you can perform a sum?
For example, I have vertical list like this:
Name State
Adam Alabama
Adam Alaska
Adam Arizona
Adam Arkansas
Adam California
Adam Colorado
Adam Connecticut
Adam Delaware
Adam District of Columbia
Bob Alabama
Bob Alaska
Bob Arizona
Bob Arkansas
Bob California
Bob Colorado
Bob Connecticut
Bob Delaware
Christie Alabama
Christie Alaska
Christie Arizona
Christie Arkansas
Christie California
Christie Colorado
Christie Connecticut
Imagine I have 100 of these names listed in the format above. Instead of me going in the list to manually "transpose" the states for each name, is there a function that exists where for for each name change in column A transposes cells (B1:B5)?
Thanks!
For example, for the Subtotal function, you can perform a sum for each name change. Instead of doing a sum, can we do a transpose?
Similar to the Subtotal function where for each change in name you can perform a sum?
For example, I have vertical list like this:
Name State
Adam Alabama
Adam Alaska
Adam Arizona
Adam Arkansas
Adam California
Adam Colorado
Adam Connecticut
Adam Delaware
Adam District of Columbia
Bob Alabama
Bob Alaska
Bob Arizona
Bob Arkansas
Bob California
Bob Colorado
Bob Connecticut
Bob Delaware
Christie Alabama
Christie Alaska
Christie Arizona
Christie Arkansas
Christie California
Christie Colorado
Christie Connecticut
Imagine I have 100 of these names listed in the format above. Instead of me going in the list to manually "transpose" the states for each name, is there a function that exists where for for each name change in column A transposes cells (B1:B5)?
Thanks!