Multiple columns grouped in 3 needed to sort

Question

I have a dataset that has 3 columns related to each other, then the next 3 related to each other, and so on in groups of 3. I want to sort each group of columns so the remaining information only has a specific Adj Code starting with a "9"  (9xxxxx, so a wildcard involved) with it's corresponding Range Name and Beg Bal keeping it's association for only rows that have a number (not null) in the Beg Bal column. Copy of sample of dataset included. Any assistance would be appreciated.

Capture.PNG

bhk · Answer

Thanks Kamran, It's a bit complicated. I'll see what I can do about the dummy information. I'm thinking I have to break up the info.

Kamran1991 · Answer

Hi @bhk,

It would be easy to solve this if you can provide a dummy data however one way to solve this problem could be  in two simple and easy step1. Sort both the groups separately 2. Join them on the basis of 'Range Name9_65'

Thanks!!