Good morning-
Will you please post some sample data, telling what is the current
difficulty and what is your desired outcome? I think what you describe
can be done easily enough, but often the solution depends on the actual
layout of the data, how the data is presents itself, etc.