how to combine/merge multiple generic fields/columns in one field/column with average calculation per generic field/column values in Splunk?

[AlexHoller]

hi,

I have following situation in splunk (see picture below).

I need following pattern in Splunk (see picture below).

I have different generic columns where the last part of the column-name (Suffix) is dynamic and unknown. I need to combine/merge this generic columns to one target-column. Within the target-column I want to calculate the average per generic field. I think the picture explains the situation very well.

[whrg]

Do you have a fixed number of suffixes? That is, are there only SuffixA, SuffixB and SuffixC?