Part numbers sorted by shift

[Patters1978]

Hi everyone

My data comes to me in the following way

123456G 1 1 1 1 1 1 1 1 1
234567B 1 1 1 1 1 1 1 1 1
345678R 1 1 1 1 1 1 1 1 1
456789B 1 1 1 1 1 1 1 1 1

The number with the letter is the first cell and is part number and shift built

The other numbers are measurements of part and are in a cell for each measurement

I want to separate each shifts measurements into another sheet to monitor build quality

The part number and shifts can be random ie
B
R
G
B
G

Etc

Any idea

 

[DanteAmor]

If the letter is always to the right of the part number, you can put a formula in sheet2 cell A2, assuming your data is in sheet1 cell A2

=RIGHT(sheet1!A2,1)

copy down