Combine columns of names and number

[akay47]

Hi,

I have several excel spreadsheets with a list of project names in column A and a score (%) in column B. There is one of these for every month. each month new projects are added and some old ones are deleted.

I would like to combine the list of project names for six months into a table with each project name in column A, and then put each month's score next to them, eg December Scores in Column B, November Scores in Column C, October Scores in Column D etc...

Eg

Project Alpha scored 60% in December, 30% in November, 40% in October and 45% in September
Project Beta was new in November, so no score for September and October, 67% in November and 31% in December
Project Gamma finished in October, so no score in November or December, 88% in October and 72% in September

etc

If I copy and paste these columns all into one workbook is there a formula or formulas to create this table?

Thanks

Andrew

 

[Thangavel]

Hi,

I have several excel spreadsheets with a list of project names in column A and a score (%) in column B. There is one of these for every month. each month new projects are added and some old ones are deleted.

I would like to combine the list of project names for six months into a table with each project name in column A, and then put each month's score next to them, eg December Scores in Column B, November Scores in Column C, October Scores in Column D etc...

Eg

Project Alpha scored 60% in December, 30% in November, 40% in October and 45% in September
Project Beta was new in November, so no score for September and October, 67% in November and 31% in December
Project Gamma finished in October, so no score in November or December, 88% in October and 72% in September

etc

If I copy and paste these columns all into one workbook is there a formula or formulas to create this table?

Thanks

Andrew

Yes, there is a way to do it. But if you provide sample excel sheet, it will help us to help you.