Hi All,
I have another question please!
See below a screenshot of my desired output in the final column.
The calculation I need to complete is:
If for a certain asset number (column A) the Number of span types (column B) = 1, then the output is simply E. I can do this step on my own without help.
However if the Number of span types (column B) is 2, then x number of "span type 1 count" need to result in Span type 1 length (i.e. Span ID (column H) numbers 5 down to 2 need to have the value in column E) and then the x number of "span type 2 count" needs to be Span Type 2 length (i.e. the 5th row for that asset type with a Span ID of 1).
There are up to 7 span types in my data that I need to do this for. If this makes sense to anyone, can someone please advise how I can do this?
I have attached the below sample dataset if this helps.
Thank you!
Solved! Go to Solution.
Thank you SO much!