Forum Discussion
Group By From-To Text without duplication
Hi, I hava data contain following columns are type, bin, section, bay and level. Logic1 If bay hasall the level from A to E range according to the Type, Section, Bay and Level then return...
Hi Saxon202202
Sorry but your logic is unclear.
Given your data and the desired result, it seems that you want to group the bays by Section and then return the min and max bays as xxx-xxx. However, your sample data doesn't have any bays that have levels from A to E. In fact, there's no E at all. How then rows 34-161 have xxx-xxx results? How are rows 1-33 different from 34-161?