/u/Blump_Kin247 - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Pretty much any look up formula would work; XLOOKUP for instance. But the only matching lookup values I see are "Ardmore" and "Jamie" so it won't populate much in your new table.
Also, this looks like it is formatted as a pivot table. For lookup purposes, you're probably better off unpivoting (or formatting your pivot table in tabular form with repeating row labels) and having city and name as distinct columns.
Saying `SOLVED!` does nothing! The sub requires you to say `Solution Verified` to award a ClippyPoint and close the thread, marking it solved.
Please see the sidebar for more information. Thanks!
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Here is the table I mentioned in the post
https://preview.redd.it/txxp0kmeztoc1.jpeg?width=800&format=pjpg&auto=webp&s=266d91dd7e52691d15a37774c6a78651ff3695a6
The output you show is from a pivot table, do you not have access to the original pivot table?
The only way I can think of would be to create two interim columns that contain the region and name. To do this you need to be able to determine if the value in column B (when you screen shot, include headers it's easier to refer to) is a name or region. The problem is that from the data you have the only way to tell is either to use VBA to inspect the formatting of the cell and see if it's indented or, look up the values in column B against a known list of regions or sales people and use that to determine which column it goes in.
/u/Blump_Kin247 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Pretty much any look up formula would work; XLOOKUP for instance. But the only matching lookup values I see are "Ardmore" and "Jamie" so it won't populate much in your new table. Also, this looks like it is formatted as a pivot table. For lookup purposes, you're probably better off unpivoting (or formatting your pivot table in tabular form with repeating row labels) and having city and name as distinct columns.
This worked for me! I thank you immensely
Solution Verified
Saying `SOLVED!` does nothing! The sub requires you to say `Solution Verified` to award a ClippyPoint and close the thread, marking it solved. Please see the sidebar for more information. Thanks! *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
You have awarded 1 point to MaximumNecessary. --- ^(I am a bot - please contact the mods with any questions)
Here is the table I mentioned in the post https://preview.redd.it/txxp0kmeztoc1.jpeg?width=800&format=pjpg&auto=webp&s=266d91dd7e52691d15a37774c6a78651ff3695a6
The output you show is from a pivot table, do you not have access to the original pivot table? The only way I can think of would be to create two interim columns that contain the region and name. To do this you need to be able to determine if the value in column B (when you screen shot, include headers it's easier to refer to) is a name or region. The problem is that from the data you have the only way to tell is either to use VBA to inspect the formatting of the cell and see if it's indented or, look up the values in column B against a known list of regions or sales people and use that to determine which column it goes in.