Summarizing data dynamically into one row

[wonka1234]

Hi,

i am trying to collapse or summarize my data into one row.

1) How can I accomplish this?

2) How can I do this dynamically, ie when it is ran as an App, sometimes the months will be 202201 to 20203, or sometimes only 1 month, sometimes 12 months, etc.

Current
Name	202201	202202	202203	202204	202205
Louis	Y
Louis		Y
Louis			Y
Louis				Y
Louis					Y
Ren				Y
Ren					Y
Expected Output
Name	202201	202202	202203	202204	202205
Louis	Y	Y	Y	Y	Y
Ren				Y	Y

Thanks

[Felipe_Ribeir0 · Accepted solution]

Hi @wonka1234 

One way of doing this dynamically

[binuacs · Accepted solution]

@wonka1234 Another way of doing this

[wonka1234]

Both ways work! thanks! 

@binuacs  @Felipe_Ribeir0 

only issue is .. I am not sure which months will be selected.. so for running as an app, what if just 202206 and 202207 are inputted? How can i get the summairze tool from binuacs answers to take in those choices?

[Felipe_Ribeir0]

Hi @wonka1234 

The summarize tool is not a dynamic tool from columns point of view, so to do this dynamically like you said now, you will need a macro that feed the xml of the summarize tool with the fields.

[wonka1234]

@Felipe_Ribeir0 think im getting confused at the XML formula and my column name being "Name".

What if my columns are:

File_Name
n_Account_ID
n_Domain
N_VALUE
202201
202202
202203
202204

and I want to max 202201, 202202, etc..

[binuacs]

@wonka1234 If you want to group by with your new fields then you should add them in the formula tool. I added the below fields as group by in the formula tool

File_Name
n_Account_ID
n_Domain
N_VALUE