Matching numbers in columns

Copper Contributor

Hi, I have a large set of data that combines three reports into one then exported into excel. The problem is that the numbers dont line up as seen in the picture. Is there anyway to sort it so the data lines up with the numbers in column B. 

I have a bunch of other columns currently hiding that need to stay attached to each of there represented numbers. 

Capture.JPG

1 Reply

@ash1624 You can sort part of the columns together as long as:

- You first select everything you want sorted together but nothing else

- The data is NOT in a table (a range formatted as a table)