Column Data on Multiple Rows

Column B contains a client identifier. The other columns track turnaround time. I need to get these columns to line up in one row per encounter. For many, one client number = one encounter but many clients have multiple encounters. Any help would be appreciated!