Filter Based on All Unique Values From Two Rows

[jonnyrask]

Hello,

Let's say I have 3 columns. A, B, and C. I would like to filter through the rows by a Group By of A and Group By of B. Then I would like to write out C from all the rows that exist in the groupings to a different excel sheet.

Example:

A	B	C
yellow	1	hi
yellow	2	bye
yellow	2	dye
blue	1	die
blue	1	hi

This should output 3 different files. In the first file, it should be the grouping of yellow,1 so it should only result in one output: hi

The second file will be the grouping of yellow,2 and should output 2 values, bye and dye

The third file will be a grouping of blue,1 and should output die and hi.

I have tried a summarize, but I cannot get the values of the other fields. If anyone has any feedback it would be much appreciated.

[fmvizcaino · Accepted solution]

Hi @jonnyrask ,

Here is an example showing how to accomplish that.

I'm using the summarize to group exactly as you need and also using an output data funcionality to generate multiple tabs.

Best,

Fernando Vizcaino

[jonnyrask]

This is what I'm looking for. Another question: now that I have all of the data posted to a sheet, instead of writing it all to one row. How do I write it to many rows. I.E. in one sheet, the output was:

hi,bye

How do I get this:

hi

bye

I would think I would have to use a transpose tool maybe?

[fmvizcaino]

Hi @jonnyrask ,

You only need to remove the summarize tool from the workflow. 

The output data tool separates data from multiple rows into different sheets also.

Best,

Fernando Vizcaino