I want to make regular paper flashcards from a excel document.

Not sure how to do it. I want to match stuff, if this is my excel document:

1 X Y

1 X Z

1 X A

2 B C

2 B D

3 E F

I want to put all the 1's on one card:

Front:

X

X

X

Back:

Y

Z

A

But uh, I have no clue how to do that.

Not sure how to do it. I want to match stuff, if this is my excel document:

1 X Y

1 X Z

1 X A

2 B C

2 B D

3 E F

I want to put all the 1's on one card:

Front:

X

X

X

Back:

Y

Z

A

But uh, I have no clue how to do that.