- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Excel Help
Posted on 12/21/18 at 9:25 am
Posted on 12/21/18 at 9:25 am
I've inherited an account set from another rep on my team who left for another job and her excel file of account information is not in alphabetical order by account name.
I'm looking to be able to resort this spreadsheet by company name but she has also included customer numbers in the same column as the company names so I can't just do a sort a to z filter.
Is there anything I can do to get this sorted or am I SOL?
I'm looking to be able to resort this spreadsheet by company name but she has also included customer numbers in the same column as the company names so I can't just do a sort a to z filter.
Is there anything I can do to get this sorted or am I SOL?
Posted on 12/21/18 at 9:43 am to jumbo
each cell in the same format? like, are the phone numbers in the same place and same length?
Posted on 12/21/18 at 9:46 am to jumbo
1. Data
2. Text to columns
3. Deliminate
4. Delininate by number
2. Text to columns
3. Deliminate
4. Delininate by number
Posted on 12/21/18 at 10:00 am to jumbo
If they're all the same length phone number (like a 10 digit area+phone), you can do a formula like this =RIGHT(A1, LEN(A1)-10)
Do that formula in a new column, fill down the spreadsheet, and then copy the results into the original company name column (make sure to paste them as values only though)
Do that formula in a new column, fill down the spreadsheet, and then copy the results into the original company name column (make sure to paste them as values only though)
This post was edited on 12/21/18 at 10:46 am
Posted on 12/21/18 at 11:56 am to jumbo
Everyone else seems to be reading this as name and number in the same cell. I'm thinking name in one cell, number in a different cell in the same column?
Makes a difference on how to approach.
Blue Barracuda has the basic solution if the name and number are in the same cell.
Makes a difference on how to approach.
Blue Barracuda has the basic solution if the name and number are in the same cell.
Posted on 12/21/18 at 1:45 pm to jumbo
the rows all have different information in them, but all of the company names are in column B
sample of column B would look like this:
row 1- company name
row 2-10- customer numbers
row 11- next company name
row 12-20- customer numbers.
sample of column B would look like this:
row 1- company name
row 2-10- customer numbers
row 11- next company name
row 12-20- customer numbers.
This post was edited on 12/21/18 at 1:47 pm
Posted on 12/21/18 at 4:09 pm to jumbo
So essentially you are trying to take the info that corresponds with each company, that's in the same column below it and move it to be in the same row?
Posted on 12/21/18 at 6:20 pm to jumbo
quote:
row 1- company name
row 2-10- customer numbers
row 11- next company name
row 12-20- customer numbers.
She should be fired for entering data that way.
This post was edited on 12/21/18 at 6:21 pm
Posted on 12/21/18 at 8:25 pm to jumbo
Pivot table is your answer
This post was edited on 12/21/18 at 9:21 pm
Posted on 12/21/18 at 9:14 pm to jumbo
quote:
the rows all have different information in them, but all of the company names are in column B
sample of column B would look like this:
row 1- company name
row 2-10- customer numbers
row 11- next company name
row 12-20- customer numbers.
You need pivot tables in your life.
Make tables for each company using that range with the company as the title and the numbers as data in the table.
This post was edited on 12/21/18 at 9:16 pm
Posted on 12/22/18 at 1:03 pm to foshizzle
quote:
She should be fired for entering data that way
She might have been!
OP, there are work-arounds like pivot tables, but spend the time to reformat that mess. If it’s not a lot of data, copy/paste may be your best bet. If it’s a lot of info but the format is consistent, a simple macro will this easy. A simple copy/paste macro will take less than 5 minutes to learn on YouTube if you don’t know how to do it.
Eta. To be clear: Copy 11-20, paste transpose to 1B, delete empty 11-20. Repeat until done.
This post was edited on 12/22/18 at 1:08 pm
Posted on 12/22/18 at 7:18 pm to jumbo
Edit: nevermind I misread the way the data was laid out
This post was edited on 12/22/18 at 7:20 pm
Popular
Back to top
Follow TigerDroppings for LSU Football News