Convert Rows and Columns to Flat File XL2007

[CarolCook]

I have a spreadsheet that lists projects in rows and hours by date in separate columns. I need to convert it to one line per project/date.

In other words, I need to get from

7/1. 7/2. 7/3. Etc.
Project. Hrs. Hrs. Hrs.
Project. Hrs. Hrs. Hrs.
Project. Hrs. Hrs. Hrs.

To

Project. 7/1. Hrs
project. 7/2. Hrs
project. 7/3. Hrs


Thanks in advance.


Any suggestions?

 

[SkipVought]

Hi,

Check out faq68-5287

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}