Hey guys current TB us set up with columns as company codes and rows as company accounts. Support was received with two columns being codes and accounts. What is the easiest way to update the tb?

Post Photo
like
Posting as :
works at
You are currently posting as works at

there is a transpose function

like

now I see what you mean, probably going to be mult layer index match. match the column then match the row id. I doubt this can be one function

Create a pivot, accounts as rows and company as columns. Balances for values.

like

Ive tried the pivot method I just can’t find an efficient way of calling the numbers to original TB.

I typically always try to formate my data so new additions add more rows not more columns

like

EY has a macro for this. You can find it in the “Interim review and group scope analyzer” page in Atlas. It’s the excel enabler in there. It’s pretty slick

like

Might be too late for this time around but you can used power query to “unpivot “ the columns. The value is that this method is super easy, and if you connect the data to a folder, as you get new TBs all you have to do is hit “refresh “ in your workbook and it will perform the same transformation on your new data automatically. It’s super powerful.

like

Added example

pretty simple script if you want to spend a day learning some code. not sure how important that switch is

If the values in the table are unique at the account / code level and the data is a string, you can do an index match or a vlookup if you created a Key on the “Support” data set. The key would be a concatenation of the Company Code & the Company accounts.

If the data is numeric you can just do a Sumifs.

Related Posts

Are there practice exams for the BA cert? If so where can I find them

like

Hello friends, I'm new to this platform. Roaming
around to expand my network horizon &
looking forward connect with some bright
minds. 😊 please help me in getting 11 likes to start DM.

likeuplifting

Joining D in a week. When do i get laptop? Do i have option to select laptop? And will they send to home ?

like

What does it mean when you dream about the same person over and over?

like

What’s the secret of business development in tech industry? Especially in e-commerce space?

like

Well he seems upset

Post Photo
funnylikesmart

Anyone have salary information for HR roles with Walt Disney? Specifically Employee Relations Manager, Based out of California.

like

Looking to finally go get my SPHR having the PHR for the past 6 years. Still value and pursuing and obtaining?

like

So my only friend was diagnosed with lymphoma so severe it has been stopping her heart now and again and I am jealous af. Everyone who wants to live is dying and then there's me. Healthy af physiclly

like

What corporate discounts can we avail for a new car purchase or lease deal?

like

What are the career prospects after an European LLM degree for someone with a non legal background. My background is in public policy and tech sales. Any ideas?

like

Any tips for young associates in estate planning? Or stories of your struggles when you first started out in estate planning?

like

How many days hire right by check process takes ?.. is there any chance of rejection in that..which can cause issue with employment.

like

I’m currently a Project Manager but looking for a career change. I have 3 YOE with a Bachelors, am interested in becoming a data analyst but I feel like I lack technical skills (no SQL experience, but willing to learn!). I take pride in asking thoughtful, purposeful questions so I have considered consulting, but it seems like that’s more for senior leaders. I also have an interest in market research but no professional experience there, just big projects in college. Any thought help - thank you!

like

Maybe I’m late to the party but I just discovered the ASAP Utilities excel add-in and my life is changed. These tools can save loads of time!

like

MBA at LBS/INSEAD/HEC/IESE still worth the ££ in tuition and time-out?

What are some funding/financing options for these programs and how long do people generally need to pay off? I am aware of prodigy but seems aggressive on rates.

like

To all my colleagues screaming that they were leaving the day Trump is elected, I hope you're serious. I want your utilization, bonus share, and the removal of your sore loser attitude.

like

Hi , can anyone tell me what’s the ctc in phonepe for Accounts payable analyst .
And also ctc for a person with 1.5yrs of experience in a financial analyst role or similar roles .

Tips for someone not currently working in tech but striving to be? I’ve submitted hundreds of applications and get a few bites here and there, but can’t get the thought of not having tech experience out of recruiters heads. Any help is appreciated.

like

Agency owners, how do you find new clients?

like

Additional Posts in Excel Genius

Do you still use index match? Is it (Always) Possible to switch to xlookup?

like

*** This is a public announcement ***

PLEASE stop hiding rows and columns and start grouping them instead

— yours, the person who is trying to understand your work

likefunnysmart

Does anyone know why negative IRR sometimes gives you a NUM error? A lot of googling and experimenting but cannot pin down what’s going on.

like

Boss seems to think I should learn Access and wants me to find a class. I can fumble around in VBA, but really only through using google. Is Access worth it or is there something better?

like

Does anyone here use ASAP Utilites as an Excel add-in? This thing is amazing.

like

What are the most useful macros you’ve seen that could be used across multiple projects?

like

Maybe I’m late to the party but I just discovered the ASAP Utilities excel add-in and my life is changed. These tools can save loads of time!

like

hoping this illustrative post makes sense.
column A=state; B=city. Cells in each column are drop downs, i.e.,can select countries/states. And, current dataset/selected choices is indicative of a category i.e., top locations. I want to build scenarios or addtl categories that ultimately auto changes values in the drop down cells. this is doable w/ lookups, but want to avoid formulas as i need the client to be able to customize the dataset/selections to view scenarios , hence drop downs. 😬😬

like

Has anyone gone through Elevate Excel by Excel Campus? Looking for reviews as I'm having trouble finding any that aren't on their website....

like

What’s the keyboard short cut to switch between open apps without using the mousing. It’s something like using alt tab or whatever the combination is

Help, simple task can’t figure it or. List of user names in one sheet compare to another list on another sheet and highlight duplicates.

like

Tips on how to quickly learn mid/advanced Excel tricks and shortcuts? Forum or training somewhere?

like

Coolest, best, or nerdiest thing you've been able to do with Excel?

like

I have a spreadsheet downloaded from a SaaS product. Every where there is drop-down multi-select or drop-down there HTML code I need to remove and simply leave my lists. Any ideas? I thought kutools would work but apparently not?

like

Do you guys use specific color scheme to make you spreadsheet looks pretty?

like

I wonder if there is a quick guide for excel ??

like

Is there an absolute moron’s guide to Index Match? I have two tables of users, some exist on table A that don’t on B, and vice versa. I need to merge them based on their email as the unique identifier

like

My Goal: I have a drop down menu in a cell. I want it to sort conditionally based on what I select. Is that possible?
Ex: If the drop down ="done" it falls to the bottom of the list.

like

Hello Everyone,
I would like to create a schedule for all of my clients. Let’s say I have platinum, gold clients etc. What would be the best way for me to schedule a call for them based on their profile of gold or platinum? For example, I would start scheduling a call every month for my top clients, then a call every quarter for other categories… I need to track the data, and make sure employees are calling them… something that would alert my employees to call such clients. Thanks!

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal