I have a table and a user requested a data and he wants me to format it in a way he wants it. I can't find a way to do it but before I tell him that, I am still working on figuring this out.
The attached file contains the data, however; instead of showing 'Branch' in a Headquarter column, he wants the value ('HDQ, and the city of HQ + State). Is it even possible? I can't think of anything.