From Horizontal Format to Vertical Format

[Jarvin24]

Hi Everyone,

I hope you could help me with my problem... I am trying to change the format in a manner acceptable by our system, which is vertically. Unfortunately for me,
I am doing this mannualy every month.

Example:

From:
A B C D E F
Account Code 1423006170 4222111010 7600000000 1236110100
Bank DATE PRINCIPAL INTEREST F/TAX AMOUNT
SCB 7/26/2013 4 3 2 5
CITI 8/02/2013 7 4 3 8

To:
A B C D
Account Code Period Transaction Date Base Amount
1423006170 7/26/2013 4
4222111010 7/26/2013 3
7600000000 7/26/2013 -2
1236110100 7/26/2013 -5


1423006170 8/02/2013 7
4222111010 8/02/2013 4
7600000000 8/02/2013 -3
1236110100 8/02/2013 -8

My current process is I copy the details then transpose and paste it on Cell A and Cell D, then put NEGATIVE sign on the F/TAX and AMOUNT manually.

Hope you coul help me with this. Actually I wish I could do this in Macro, but I dont know the codes

Thank you so much

[vlady]

Just to get started... I'm assuming the dates would be in an incremental state in the table..

look attachment.

From Horizontal to Vertical 2.xlsx

[JBeaucaire]

Assuming your two sheets already exist and the headers are all there on the ENTRIES sheet, this will take data from row6 down on BANK FILE and paste into ENTRIES in the format you've demonstrated.

Please Login or Register  to view this content.

[Jarvin24]

JBeauaire,

OMG!!!!!...... for real? So working.... thank you thank you so much... I wish I'm like you ^_^...