CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulagoogle-sheets-api
goatherder13
goatherder13

Reputation: 49

Can I sort values alphanumerically in google sheet and ascend the rows?

I have a google sheet with room names, but they are formatted like (M355) and then the purpose of the room? I know how to sort values alphanumerically but you have to use a written formula. I need the cell next to the rooms to stay with the room number, so I can see the extra data that goes with it. The attached image shows what I mean. enter image description here

I need the cell next to follow but it doesn't sort right. Has anyone experienced anything like this? I could manually copy and paste the 50 rooms but I ain't feeling that, I also would like it to be able to revert to what it is now too if possible.

Thanks!

Upvotes: 0

Views: 123

Answers (1)

Rodrigo Biffi
Rodrigo Biffi

Reputation: 428

You don't need a formula for that. You can just select the first row with your headers (assuming you have such a row), and create a filter.

enter image description here

By doing this, every data in the sorted column cells will bring its full row togheter.

Upvotes: 1

Related Questions