Translate columns into start & end dates

[#1]

Hi All,

I have a table which looks like this:

Ref No.

Project Name

Start Date - Project

End Date - Project

Jan (2014)

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Q1 2015

Q2 2015

Q3 2015

Q4 2015

1

Test

01/01/2013

31/03/2014

2

2

2

2

Test 2

-

01/05/2015

1

1

I have some project data (columns 1 - 4) and some resource data (months) in a table. I need to check if the start and end dates listed mach up with the data in the Jan, Feb etc columns.

So, how best can I scan all of the columns and return the first column that contains a value and the last column that contains a value. Once I have that information then I was thinking a mapping table would be the best way to return a date...?

Thanks!

A

[#2]

Hello,

I'm not sure if I understand but attach an example:

Best Regards.