Data validation issue

[Sophster]

Hello,

I have had to consolidate data into a summary. The data involves ad-hoc rows but they remain unchanged. Only the column change but unfortunately it is not set in a format where I can drag the data horizontally to reflect the correct column.

For example I have the following list and I would like to be able to select it and change the "L" to "G" across the list.

L78
L85
L91
L99
L130

I'm trying to get
G78
G85
G91
G99
G130

Any help would be highly appreciated