Quisiera saber como hago? Para que una columna registre las modificaciones de una fila de varias columnas por ejemplo 20 columna

Quisiera saber como hago para que una columna registre las modificaciones de una fila de varias columnas por ejemplo 20 columna y también tengo otro problema con un excel: imagínense un excel de 4 filas y 5 columnas con parámetros diferentes ejem año día mes pero que la ultima sea A o B osea que se pueda poner o A o B y en la quinta se llame numero... Lo que quiero hacer es que en una hoja aparte aparezcan los datos de A y de B solo cuando tengan el mismo numero un ejemplo
año día mes A o B numero
1000             1                  1                        A               1
1889             5                  10                      B               1
1111             2                  3                        A               2
3333             1                  3                        B               2
osea en la otra hoja del excel quisiera que aparezca asi
                          numero=    1
                               A                                                                       B

año                  1000                                                                     1889

dia                    1                                                                              5
mes                    1                                                                           10

Análogo si fuera el numero 2... Espero se haya entendido gracias

Ya sea aca o en mi correo axn_aiur...
Llllllllll llllllllllllllllll lllllllllllll llllllllllllllllllll llllllllllll lllllllll lllllllll llllllllll llllllllllllllllll llllllllllll lllllllllllllllll lllllllllll llllllllllllllllll llllllllll llllllll llllll llllllllllllllllll llllllllllllllllllll llllllllllll llllll llllllllll llllllllllllllllll lllllllllllll llllllllllllllllllll llllllllllll lllllllll lllllllll llllllllll llllllllllllllllll llllllllllll lllllllllllllllll lllllllllll llllllllllllllllll llllllllll llllllll llllll llllllllllllllllll llllllllllllllllllll llllllllllll llllll llllllllll llllllllllllllllll lllllllllllll llllllllllllllllllll llllllllllll lllllllll lllllllll llllllllll llllllllllllllllll llllllllllll lllllllllllllllll lllllllllll llllllllllllllllll llllllllll llllllll llllll llllllllllllllllll llllllllllllllllllll llllllllllll llllll llllllllll llllllllllllllllll lllllllllllll llllllllllllllllllll llllllllllll lllllllll lllllllll llllllllll llllllllllllllllll llllllllllll lllllllllllllllll lllllllllll llllllllllllllllll llllllllll llllllll llllll llllllllllllllllll llllllllllllllllllll llllllllllll llllll llllllllll llllllllllllllllll lllllllllllll llllllllllllllllllll llllllllllll lllllllll lllllllll llllllllll llllllllllllllllll llllllllllll lllllllllllllllll lllllllllll llllllllllllllllll llllllllll llllllll llllll llllllllllllllllll llllllllllllllllllll llllllllllll llllll llllllllll llllllllllllllllll lllllllllllll llllllllllllllllllll llllllllllll lllllllll lllllllll llllllllll llllllllllllllllll llllllllllll lllllllllllllllll lllllllllll llllllllllllllllll llllllllll llllllll llllll llllllllllllllllll llllllllllllllllllll llllllllllll llllll llllllllll llllllllllllllllll lllllllllllll llllllllllllllllllll llllllllllll lllllllll lllllllll llllllllll llllllllllllllllll llllllllllll lllllllllllllllll lllllllllll llllllllllllllllll llllllllll llllllll llllll llllllllllllllllll llllllllllllllllllll llllllllllll llllll llllllllll llllllllllllllllll lllllllllllll llllllllllllllllllll llllllllllll lllllllll lllllllll llllllllll llllllllllllllllll llllllllllll lllllllllllllllll lllllllllll llllllllllllllllll llllllllll llllllll llllll llllllllllllllllll llllllllllllllllllll llllllllllll llllll llllllllll llllllllllllllllll lllllllllllll llllllllllllllllllll llllllllllll lllllllll lllllllll llllllllll llllllllllllllllll llllllllllll lllllllllllllllll lllllllllll llllllllllllllllll llllllllll llllllll llllll llllllllllllllllll llllllllllllllllllll llllllllllll llllll llllllllll llllllllllllllllll lllllllllllll llllllllllllllllllll llllllllllll lllllllll lllllllll llllllllll llllllllllllllllll llllllllllll lllllllllllllllll lllllllllll llllllllllllllllll llllllllll llllllll llllll llllllllllllllllll llllllllllllllllllll llllllllllll llllll llllllllll llllllllllllllllll lllllllllllll llllllllllllllllllll llllllllllll lllllllll lllllllll llllllllll llllllllllllllllll llllllllllll lllllllllllllllll lllllllllll llllllllllllllllll llllllllll llllllll llllll llllllllllllllllll llllllllllllllllllll llllllllllll llllll llllllllll llllllllllllllllll lllllllllllll llllllllllllllllllll llllllllllll lllllllll lllllllll llllllllll llllllllllllllllll llllllllllll lllllllllllllllll lllllllllll llllllllllllllllll llllllllll llllllll llllll llllllllllllllllll llllllllllllllllllll llllllllllll llllll