Someone used Excel (2003) like an old fashioned paper spreadsheet. About 50
names on column A. Column headings in Row 1 are program numbers. Columns B to
whatever, about 60 columns, are populated by fractions representing each
person's percentage of time devoted to programs. A person's total time might
be distributed from one program to a maximum of 15 programs.


I think this is a huge waste of good spreadsheet real estate. Less than 10
percent of the cells are populated.

However, what I want to do is to extract the percentages, separated by comma
if more than one, for each person into a cell, say cell DA7 for the person
whose name is in cell A7, in the same row as the person's name. Also the
corresponding programs, also separated by comma if more than one, in say cell
DB7.

Is this possible?