How can I iterate/loop through a table without using VBA?

Whenever I have to do something like this, I throw VBA at it. However, I'm working for a client that doesn't allow VBA or macros to be run on-site.

I have tabularised data:

____A B C D E F G H I J . . .
Date 1 1 2 1 4 1 1 5 1 0 1
Date 2 1 0 0 0 0 0 1 1 0 1
Date 3 2 0 2 1 2 5 1 5 1 0
Date 4 0 0 0 0 0 0 0 0 0 0
Date 5 1 1 1 0 0 0 0 0 0 0
.
.
.

I want to loop through this table on different dates, and create a table that looks like this:

Date 1 A
Date 1 B
Date 1 C
Date 1 C
Date 1 D
Date 1 D
Date 1 D
Date 1 D
Date 1 E
.
.
.

How can I do this using standard excel formulas and not using VBA?

Please see attached for workbook data.

Try this,

Please Login or Register  to view this content.