Manipulate dynamic rows values and dynamic columns values

Hello!

I have a file that has 'entities' in a single row and 'account numbers' in a single column. The cells that intersects these rows and columns have amounts in them. I want to create a 2 column table out of this data. One column will have unique reference (which is a combination of entities & account numbers) and the other column will have the amounts. I've attached a sample which will better explain what I want.
I would've recorded a macro , but the file will have different number of rows and columns each time.
How do I do this?

Hi

Here goes.

Please Login or Register  to view this content.

rylo