Grouping Fields onto Same Line

[anm252]

Hi all--I have a data set I'm working with that has numerical ID values for each grouping I'm interested in. There are 4 different data fields that make up the criteria of each ID. 1) Billing ID, 2) Billing Prov ID, 3) Rendering ID, 4) Rendering Prov ID. Regardless of the combination each ID can have 1-2 of these data points but they will never come through in the database on the same line. I have an example attached. What I want to do is group all of these fields on the same row. There will always be 2-3 blank columns for each ID which is just fine. I have 2 sheets in the attached example. One that shows how the data comes through unformatted and one that shows desired format after using Alteryx to group. I tried joining my unformatted output on a summarized by "id" output like below but was unsuccessful:

Any assistance is greatly appreciated.

[JagdeeshN]

@anm252 ,

Have you tried using the summarize tool for this?

Best,

Jagdeesh

[anm252]

Hi Jagdeesh--I should've probably provided a better example but I do think I need to use the summarize in some way similar to what you just did. However is there a way to produce the same result without using Max? For example, if I have an ID that has this as the raw data:

ID   Billing ID        Rendering Provider ID

4    777777777     

4                           1111111111

4                           2222222222

4                           3333333333

I'd like the output to be this:

ID      Billing ID     Rendering Provider ID

4     777777777     1111111111

4     777777777     2222222222

4     777777777     3333333333

How would I do that? Using Max for Billing ID or Rendering Provider ID would lose me that formatting. Thanks again.

[JagdeeshN]

Hi @anm252 ,

I your second example it looks you are also looking to fill in the BillingID column for where it is null.

For this specific purpose you can use the multirow formula tool. 

Please find attached an example.

Best,

Jagdeesh+

[anm252]

Hi Jagdeesh. Yes--essentially for each ID there can be up to 2 of the 4 fields used (BillingID, RenderingID, BillingProvID, RenderingProvID) in any combination and when that is the case I'm trying to match everything. For example, if I have 2 BillingID and 5 RenderingProvID then I'd like to populate 10 rows where each value for BillingID and RenderingProvID is filled with values. I hope that  makes sense.