How to Group By two different criteria in a column?

[abhishekyx]

Dear Team,

I am looking for some idea on splitting the column by two different criteria. 

Attached image for reference. 

In the image you see - AA, BB, CC as 1 Category and A1...B1...C1... as another category. 

[Qiu]

@abhishekyx 
Can you kindly provide the sample input and sample output in txt format?

[aatalai]

@abhishekyx Alteryx can have only one name for a data field, or is this more for a final output?

You could try appending the names e.g A1 becomes AA-A1 if that would be any use? That would be done using the dynamic rename tool under formula using an if function