This may be a tough ask...but does anyone know a way to to take tabular time-phased data and convert it to columnar without using power query / alteryx / tableau?

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

Transpose

like

And I would need it to fairly automated as the client has very basic excel skills

like

Either unpivot in power query or write a macro in Excel VBA

like

If your client is a retard they will not be able to maintain anything you give them.

Your best bet is to build them an excel function that does exactly what they want and hope that you've left the building before it breaks.

Related Posts

Waiting now 13 months for a decision on a pre-answer motion to dismiss for an employment/business law dispute. Been administratively adjourned eight times and bounced around now two judges. The applicable law is straightforward, requires some reading but nothing heavy lifting, so it should not take this long. Of course client is livid, but what can I do? Has anyone ever actually had any luck with a phone call to chambers in this situation? And what's the longest you ever waited for a decision?

like

Guys any Internal Portal to Check the Openings in HCL for the persons on Bench...

Pls do inform

Hi I have 2.6 years of React.js experience and and current ctc is 3.81. I have received offer from TCS with 7 lpa for patna location. Same offer from Span Idea System Jodhpur location. Which one should I join ?
It's my first switch.

like

Has anyone taken the Leader as a Coach Mastered programme, through Meyler Campbell?
Interested in your thoughts on it if you have.

like

Do managers at RSM get shares of the firm?

like

Got an offer letter for a new job, but it's $10 less than what I make currently. What can I ask for in a benefits/sign on package to compensate for the drastic wage difference?

like

𝐂𝐨𝐨𝐤𝐢𝐞𝐬 𝐢𝐧 𝐒𝐀𝐏 𝐒𝐮𝐜𝐜𝐞𝐬𝐬𝐅𝐚𝐜𝐭𝐨𝐫𝐬

In SAP SuccessFactors, cookies are available for each solution in the SAP SuccessFactors HXM Suite. There are different types of cookies like Session and Persistent, Sample list below:

Post Photo

How easy/hard are the Big Tech Strategy & Operations roles out of Accenture Strategy post-MBA? How long do people typically stay in consulting before getting a good offer from one of these companies?

like

Bonuses? Do you get them? If yes, what’s the estimated/expected $?

likefunny

Did anyone from EY got picked up in the second lottery?

like

Hi what will be the take home if fixed is 14lpa and 18lpa respectively?

like

Have you had thoughts of quitting the job during pregnancy? My tolerance of low efficiency and meaningless grind is getting so low that it’s a constant thought in my mind. Does this get better later in the pregnancy?

like
like

I am looking for some career advice.

Post Photo

Let's grow this puppy. Deals Deals Deals!

What exactly is the difference between systems engineering and IT implementations? Is there mostly a focus on custom built applications?

like

My nephew who's a journalist student told me about the Wag The Dog movie. As a senior journalist, I feel bad about not seeing that gem before. Please don't be like me and watch it if you haven't by now.

like

Before you get carried away by your deep conviction(s), remember if you must stand for something you must be willing and ready to stand alone, otherwise grab a seat.

like

Hi - does anyone know the level hierarchy in New York Life insurance? Is Corporate VP lower than VP?@new york life

like
like

Additional Posts in Excel Genius

Hoping someone can help me write a formula for the blue cells. Trying to return the unique ID from my data using 2 lookup criteria where the first is the Name in column A and the second is the date in column B that falls between the appropriate date range for that Name in my data. All names are spelled/formatted exact same in lookup table and data table so no issues with respect to extra spaces, periods, etc. Picture attached for reference. Any help is greatly appreciated.

Post Photo
like

Hello All,
Excel help please. I’m trying to combine 3 tabs into 1. So on tabs a,b,c I have wire instructions that go to different places, but they all have the same field names/format. However the number of rows for each tab will vary from day to day. I need to make a fourth tab that shows all the rows from a,b,c consecutively. Because the number of rows change, I can’t find the best way to collate all the rows into one table. I can use a macro or lookups or a source formula. Please advise!
Mo

like

I want to learn more about excel. Are there courses that you would recommend?

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

Does anybody have a good resource that would let me link data from QuickBooks Desktop to Excel?

like

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

like

Does anyone have any recommendations for a really good excel training course? I’m based in LA and would prefer an in person course but if there is a highly recommended online program, I’m open to that too. I’m looking for more detailed pivot table instruction and more advanced classes in formulas and macros macros

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

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

like

How do you all prepare for excel/financial modeling tests? Every firm is different, so I imagine there are multiple effective ways to get ready.

likehelpful

Hey guys, I have a Google spreadsheet where each cell has multiple links separated by semi-colons.

How would you get the links to show up in different rows WITHIN a cell? (Pictured is what I want to achieve).

Thank you so much🙏

Post Photo
like

How TF do I attach the SharePoint version of a slide deck in an email? Every time I try to share, it gives me the link in the email body instead of an actual attachment to open in app. PLEASE AND THANK YOU

like

Hi, two of my colleagues keep getting a run-time error 91 when trying to run a macro on this worksheet. However, I am unable to detect the issue nor find a solution as this does not happen to me when trying to run the same macro. Any way I can find a solution?

like

My excel columns have switched to numbers (so I know have numbers for columns and rows). This has also made all of my formulas incredibly confusing. Was this part of some update? How can I switch my columns back to letters?

like

Coolest, best, or nerdiest thing you've been able to do with 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

I’ve heard of power query/pivot multiple times but what are their advantages compared to traditional excel? Anyone can share some examples?

like

Dear auditors, please explain how you pick samples for substantative testing.

like

Really wish my clients didn’t use Google Sheets. This sucks.

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