asked on

4N shows Data by Columns

4N wBPwYs add to smry PTRMPMT
29217708a.xlsb

1- from sheet1 source to DESTINATION = SUMMARY sheet
sheet1 SUMMARY
source Destination
PAIRS TOP columns BX BY to AC AD
TRI TOP CJ CK AF AG
REPEAT CZ AI
MID PAIRS EO EP AK AL
MID TRI EY EZ AN AO

2-the existing years and those to be added in the future

ADRIANA P

ASKER

i update the file to the last
29217708a.xlsb

Martin Liss

I don't understand the question so please try again. When you do, please use Google Translate to translate your Spanish into English. It would also be nice if you added a sheet that shows what you want since what you show in your question is hard to understand.

No entiendo la pregunta, inténtelo de nuevo. Cuando lo haga, utilice Google Translate para traducir su español al inglés. También sería bueno si agregara una hoja que muestre lo que desea, ya que lo que muestra en su pregunta es difícil de entender.

ADRIANA P

ASKER

Martin Liss

If you don't like the headings I can change them.
29217717.xlsb

ADRIANA P

ASKER

If you don't like the headings I can change them.

they can be from the other side
it is my habit to read

Martin Liss

Right now column like 'Y' read top to bottom. Do you want top to bottom or bottom to top? Columns like AC:AD read right to left. Do you want right to left or left to right?

En este momento, la columna como 'Y' se lee de arriba a abajo. ¿Quieres de arriba hacia abajo o de abajo hacia arriba? Columnas como AC: AD se leen de derecha a izquierda. ¿Quieres de derecha a izquierda o de izquierda a derecha?

ADRIANA P

ASKER

bottom to top

left to right

ASKER CERTIFIED SOLUTION

Martin Liss

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ADRIANA P

ASKER

Great Job !
Best Expert !