Given below is the dataset. Kindly note that the dataset has been shared horizontally i.e. same field repeats after every 3rd filed (although the field names are different - but as we can see below, based on the data that each field represents, one can infer the similarity in the fields (eg - field name -> 1, 4 & 7 imply same meaning)
This is the outcome that I am expecting (but subject to an IMPORTANT NOTE specified below this snip):
I want to make sure that workflow is dynamic enough to capture the data from new fields that would get added with similar pattern going forward i.e. in essence, same filed repeating after every 3rd field (Eg: when new fields are added as 10, 11, 12; then field 10 will imply same meaning as field 1,4 &7....& so on)
How does this look @Chirag_KRCPL? It should be fully dynamic as the data is transposed and a repeating 1-3 count is applied to all values that come through. Workbook attached - let me know if you have any issues!