Hi All,
I have been asked to transform data we receive as a list (Output in attached) into something more representative of that shown in the result sheet also on the attached.
In short this is basically taking the numbers beginning with 81 and making those the column headers and the then the corresponding numbers below being listed in this new column. The amount of numbers involved can vary massively from 1 upwards to there is no pattern here. The only consistent factor will be that the 81 numbers will be there albeit again they could be in a different order or sequence each time the data is presented.
Ideally I would like to take the raw data (output) each day it is produced and in turn end up with the result without having to make any additional amendments / manipulations to however the result can be calculated,
Many thanks,
Gaz
Bookmarks