How to combine data from two rows, when certain criteria is met
- by Corde Parker
I'm trying to make this Excel document but I want the AdminTimes for the same LastRxNo to be on the same line. So if the LastRxNo is the same, have one line and the AdminTime column will have multiple values. Here is a picture of what I want it to look like
Any ideas? I was thinking an IF function, but I'm not too familiar with Excel to get it to work.
It was just made in the Microsoft Query tool in Excel.