You’ve got names in a column cell and you want to separate first, middle and last names. Easy to do if ALL the values were the simple first…middle… and last name. But what if some didn’t have middle names? What if some had two or three middle names?
Easy if it was like 5 to 10 names. 20 names…not that easy...2000 names? Much harder to do. But if you’ve got power query, it’ll only take under 5 minutes to do. Plus once you set it up, you can do it over and over again.
Monday, July 3, 2023
Monday, June 26, 2023
Sort by Column - Google Sheets
There are some quirks with Google Sheets. Usually sorting from A to Z or Z to A is a simple process , and when you have a data range to analyze in Sheets there are various additional options you have. BUT watch out for sorting by sheet or sorting by range in google sheets.
In addition, one other sort capability you have is you can also sort by color! But it's not intuitive, since it doesn’t readily show up in the sort menu, but I'll covered how to “enable” it.
Monday, June 19, 2023
Convert One Column Address List Same & Different Row Amounts
When you get a list of addresses, sometimes it’s in a good format to do a mail merge. That’s when you’ve got the name is one column, address in another column, etcetera. If you get an address list with all that information in ONE column, it’s not that hard to copy and paste transpose to another set of cell ranges IF there aren’t too many records (less than five).
When you get a list of records that are higher, say more than 10 records, then it becomes more time consuming. Get to 20+ records, and you might as well forget about taking the afternoon off. BUT if the records follow a consistent and static structure, then you can use some formula tricks to take care of it quite easily. AND if the records don’t follow a structure, but have some sort of pattern, there’s also a way to take care of that and unstack this data.
Subscribe to:
Comments (Atom)