I have input data in sheet 1 as it appears below and need to get the results in below three ways in separate sheets. Header not included.

Sheet1: Input Data

asdfg1 asdfg1, asdfg1%, asdfg1, asdfg1%
asdfg2 asdfg1#, asdfg1
asdfg3 wxy1#, b-r-a-d-e-1


Sheet R1: Result 1

asdfg1 asdfg1
asdfg1%
asdfg1
asdfg1%
asdfg2 asdfg1#
asdfg1
asdfg3 wxy1#
b-r-a-d-e-1



Sheet R2: Result 2

asdfg1 asdfg1
asdfg1 asdfg1%
asdfg1
asdfg1
asdfg1 asdfg1%
asdfg2 asdfg1#
asdfg2 asdfg1
asdfg3 wxy1#
asdfg3 b-r-a-d-e-1

Sheet R3: Result 3

asdfg1 asdfg1, asdfg1%, asdfg1, asdfg1%
asdfg2 asdfg1#, asdfg1
asdfg3 wxy1#, b-r-a-d-e-1