•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How do I alphabetize one column making sure the corresponding data in an another column matches the change?
Our take
If you're looking to alphabetize one column in a spreadsheet while ensuring that the corresponding data in another column remains aligned, you're tackling an important aspect of data management. This process typically involves creating a sort that maintains the relationship between the two columns. By using functions like VLOOKUP or sorting tools available in your spreadsheet software, you can effectively reorganize the data.
I want to make a copy of a spreadsheet that’s ordered by a reverse look up, it’s two interdependent columns of data but so far I can figure out how to alphabetize one and have the other column of data adjust to the change in order?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- How to handle data from different sources when columns are in different orders?I regularly get CSV exports from multiple clients. Each client uses their own column order. One puts names in column A and dates in column B, another swaps them. Manually rearranging every time is driving me crazy. What's your go-to method for standardizing columns from different sources? Power Query seems powerful but I'm not sure where to start. I've tried INDEX/MATCH with header lookups, but it gets messy when column names vary slightly. Also open to VBA solutions if they're reusable. Any tips or templates you'd recommend? submitted by /u/biggy_boy17 [link] [comments]
- How to link to columns togetherHello I have some data from countries and want to sort it alphabetically but also want the number next to it to stick to whatever country it's from. submitted by /u/General_Bike_5212 [link] [comments]
- combining two columns into one without vstack or an arrayi have two columns of names on two separate sheets of a workbook. on a third sheet, i want to combine all of the (unique, but that part is easy) names into one column. from there, some vlookups nested in iferrors pull in additional from whichever sheet the name came from (looks for the name in the larger spreadsheet; if it's there, do the vlookup, but if there's an error, check the smaller sheet and do the vlookup). vstack does this nicely, but because it returns an array, i can't use basic sorting anymore. the sort function exists, but we want to be able to do different sorts at different times and this sheet is for use by my less tech savvy coworkers, so i can't rely on that. a recommendation of =query1 & query2 was attempted but i ended up with the first row of each spreadsheet in one cell. please let me know if anyone else has ideas! i've been googling but keep hitting walls :') submitted by /u/nidoqueenofhearts [link] [comments]