I did this manually but would there be a way to pivot the dates (day/month) in the rows years in columns with raw data being (date/month/year) needed a visual of same day different year

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

Use power query

like

I second power query ^^

like

Just learned how to use power query. It literally would've saved hundreds of hours over the past few years 😭😭😭

like

Any time you do something and think, "this is absurd, there must be a better way!"...99% of the time there is.

like

This is the raw data I’m working with

Post Photo

Maybe define each date with a =day(), month(), function in two columns and grab the data with right(4) grabbing the years? Or split the data using “/“ as a delimiter and define the resulting fields as D/M/Y?

Yeah - I would do GTs second option - just text to column it to create a year column and add the day and month field back together then pivot

Use a lookup where column headers are years

Add a column =Text(cell, “yyyy”)

Just group by year month and day. Put years across top and month day as rows

Related Posts

Got made redundant late last year. Saw a job ad today for essentially the same role, but with a designer title and significantly less pay but the same amount if not more responsibility. 😬

like

For those who have left public, where’d you find the new position? Linkedin, recruiter, etc?

like

There's plenty of chatter on who the worst firms are, but who do you consider the best?

like

Good Morning,

How much % of hike TCS offer for Lateral Join. I heard 30-40% or Maximum 50%..Is it right?

like

Is it ok to eat carbs for every meal when you are trying to lose weight? I’m talking about one slice of toast or 40 g of rice. Or should you eat carbs only during the days you workout.

like

Flight at 4:30 asked for volunteers and offered $800 United voucher to take the 9:55 flight, first class seat.

I took it. Was this a good move? Wwyd

like

My partner is so bad at this and so emotional at all times that it makes my job way harder than it should be. I sneak away to get work done and to avoid the daily tantrums.

likeuplifting

Hi all
Can ibm give 19fixed for 7A band Senior Data engineer role
Yoe 4.5 years

Holding offers for 22, 23.5., 25.8 from different companies but choose ibm because of job security.

Please let me know if ibm can give 19 fixed + retirals in my case.

like

I joined a company in industry in October. The company accelerated annual raises to be effective on Jan 1. I didnt get one, I assume due to timing. Should I reach out to HR to at least inquire if that is the situation?

like

I’m a third year in corporate and want to switch to tax. Am I too late? How do I ask my firm?

like

Why is the Chicago market so dry the past 6 months or so. It’s a little worrying.

like

Any recommendations for Best home security systems that are also not very expensive?

like

How good Publicis sapient for java developers and they are offering associate technology L1 and what package i will expect for 2.5year yoe?

like

I got and offer from PWC banglore and global logic of my hometown both are on same package can someone suggest me to choose a Big4 or growing mnc

like

Any items you thought were allowed by airline but got objection from while traveling from India to us.

like

How can companies justify cutting research and development expenses when they literally have no future without it

like

Hey!
I am a final year student, I got an offer from JPMC through Code for Good 2022. We got a mail requesting our location preference - Hyderabad, Bangalore or Mumbai. How are the locations different from each other, pros and cons of each location?

Thanks!

like

This group is for providing a unique platform for utilization of opportunities and delivering quality results in political consulting. It will also act as a go-to go network for all types of Political Campaigning & allied activities.
Plz, invite your connections...

like

Additional Posts in Excel Genius

Is there a way/shortcut, without using a mouse to drag cells down, to fill a range of data following a trend? I want a column with the first day of each month up to a certain date (row number). Thanks

Story time: I was on a trip about 15 years back, doing some Excel work on a ferry ride - your basic pseudo-database work that is so common. I started talking with the guy sitting next to me and after a while he commented on what I was doing, “You know, that’s really not what I designed that for…” (continued)

likefunny

Alternatives to Power BI for Mac users? Trying to branch out of excel. Reports aren’t too stable with excel

likefunny

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

Hi Excel Gurus, is there was a non-macro approach to input fields?

I have Worksheet A with merged cells used for user input. I attempted to reference values from Worksheet A cells and populate Worksheet B via direct reference. Also using a parameter (name) from Worksheet A to differentiate rows in B.

I keep getting a Spill error as I am taking a merged cell (3+ rows) value from Worksheet A and trying to put it into a single cell in Worksheet B.

Is this a valid approach for input collection?

like

Any macro experts that can help changing this 3 generation family tree generator to a 6 generation one (template link provided in comment below)? Provided by Microsoft but I have no idea how to edit this macro to allow more generations, and this is the easiest to generate template I've seen unfortunately

like

I'd like to know if anyone has ever pressed the excel help key (f1) on purpose. It is literally the most useless and obnoxious shortcut for excel. I accidentally press it 5 times a day at least.

likefunny

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

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

Having problems converting pdf files to excel? I can work on that. Just let me know. :)

likefunnyuplifting

Hi Guys, just started a new job and they want me to build an Gannt chart in Excel. I have experience in P6... but excel seems to be a lot of work with little customization. I downloaded an app, but am still have trouble showing all the info in a zoomedout view to give leadership a high-level snapshot of a 6 to 10 month project. Does anyone have a customizable spreadsheet they can share that let's me gets into the weeds, but also shows a high level view for executives?

like

I have to revert a scale of 1-13 to 1-5, any advice on how to do / automate this? TIA 🙌🏽

like

Hi all, noob here. Hoping someone can provide a more efficient way to do this.
I have a bunch of qualitative data from a pivot table that I’m concatenating in single cells. At present, I’m clicking on each individual cell to add it to the cell, is there a faster way to do this? Like a sum product with qualitative data?

like

What are your favorite excel macros to make you more efficient at work?

like

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

like

Anybody know of a great typing software? I want to start again from scratch and learn proper finger alignment. Thanks!

like

Is there a good tutorial out there to automate creating pivot tables and then creating a PowerPoint pres with those pivots? Trying to do with with macros and the syntax is really giving me a hard time.

likehelpful

Hi geniuses. Hopefully I can get some help in this.

Scenario: Three tables joined by Power Query to make a Master Pivot table. The idea is having a lot of sheets and each one represents a client template and includes info like (phases, people involved, what went well). I want it to be automatic and when someone fills info on a certain cell in the client template, it’ll update to a specific cell on one of the tables. Afterwards, mimicking this logic to other workbooks.

Thanks geniuses!!

like

Is there an enhanced "sumifs" that will sum rows and columns based on two different criteria?

like

Need some urgent help with using if and vlookup together. Anyone willing to help via direct messages please?

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