How do you repeat item labels when the data is not in a pivot table

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

Filter on blank, so you get only the cells without labels. In e.g. A2 enter =A1, then fill to all blanks. You can use Ctrl D as a shortcut to fill all selected on a filtered range without overwriting the actual labels.
I'm also guessing here at what you're really asking.

like

Use a reference formula (such as index match)?

Not sure I'm following the goal here

like

As an example, I want all the rows in that section to show "total" before "x", then repeat "x" in the next section

Post Photo

Like this:

Post Photo

Normally I would "repeat item labels" if it was in a pivot table but this is just raw data

Related Posts

Consulting Cat Dads -- how did you handle cat litter during pregnancy while you are traveling? My wife is afraid of a toxoplasmosis infection from exposure. What worked for you?

laid off in Oct but ended Jan with 4 in-persons and good feedback. fast forward a month - ghosted twice, one put on hold, and one no. ~1 month of unemployment left - f@&k i feel worthless.

like

My company (biotech start up >50 employees) are looking to collect diversity data about current employees to provide to candidates when they ask about the company as well as to investors. Any thoughts on whether this is industry standard? What roadblocks to be aware of? Advice on how to go about this as meaningfully as possible?

like

For Canadians / Mexicans - can we get FP&A or FDD jobs with TN accounting visa? For context I am in FAAS and I got this with the TN, wondering if I can move to industry with a TN

like

Recently approached by a partner at Big 4 consulting practice to join his group. After spending majority of my career in house I’m having some angst over the pressure to develop new business. Anyone gone from consulting to corporate law or vice versa?

like
like

Hello folks

I have offer in my hand from tech Mahindra with 6.30 lpa which includes 10 percent variable. Also Im holding one start up company offer with 7 LPA without any variables. Which one should I choose ??? Tech Mahindra will be good choice as per job security ???

Also with new offer can I ask counter offer in tech Mahindra .?
And if I did not continued with tech Mahindra will they blacklist me ???
#seriouspost #help

like

Who else is hodling IOTA? Do you plan to keep on hodling?

Is it okay to leave a job after one month of working there? I was unemployed and needed some reliable income and stability. Now was just offered a job that pays a lot more and is much more fulfilling.

like

hello!
I am starting my 3rd year as a behavior specialist for a cluster school for ASD students in a public school county in FL. I just graduated with my Masters in ABA and look forward to learning!

likeuplifting

To those of you who are stuck outside of US and working from your home country, did your company file any sort of H-1B amendment mentioning your home country address? Or can we work w/o an amendment?

like

I want to attend grad school starting in Aug2020. When do I tell my team? Feels like there is a better way than give my two weeks when I’ve known 5+ months.

like

Is there a videogames bowl?

like

Lunch discussion at the office, curious to hear your thoughts: Does one need to learn data science first to be a good data engineer / architect? Why / why not?

like

I currently work for Chubb and have been for the last 8 months. Prior to Chubb I worked for Farmers for about 4 years. If you have any questions about Chubb feel free to ask.

Also, if you do work for Chubb I would like to see title and salaries. Chubb

like

I am looking to hire a mid level associate for my team. How can I conduct an effective interview to find someone who be committed to our work? Interviews are so superficial.

like

I am a middle school social studies teacher and my husband is a high school art teacher. He has been an art teacher for a very long time and he’s not super proficient with Google classroom but I am. I have been helping him with lesson online resources & creating hyper docs for the lessons. He is struggling with the students not having a lot of supplies at home and how to have them create multiple day art pieces.  he teaches at a low income area, how is everyone handling supplies to students? 

like

Currently looking for Tech consulting/ Implementation consultant/ privacy roles in London. I have both CIPP/E and CIPM.
Please let me know if you know any roles that are available? Or any recruitment agencies you can refer me to

Thank you!

Am wrking TCS. For am medical emergency I have applied for salary advance today and it is approved.Buy amount is not credited. Ould any one let me know when will I get that money. I need that money for an medical emergency.

Is that possible will I get today?

Tata Consultancy

like

Additional Posts in Excel Genius

What are your top Excel ninja tricks? Ones that few people know...

like

I have three lists. Each is a list of processes. Each list represents one hierarchy level. Is there an easy way to get from three separate lists to one list ordered like shown on the right?
Thanks for your help fish!

Post Photo
like

Hi team i have a bit of doubt.
I have an excel sheet where column A is the order numbers. I want to add comments in column G.
There are many repetitions in order numbers but they are all sorted in ascending so all the repetitions are below one another.

If i have a comment, how can i automatically paste that same comment in all the repetitions of that order numbers if i write it in the 1st instance.

Thanks in advance

like

What is y'all's preferred clipping tool? One of my former companies had a great simple program that was only like $50 and worth every penny.
Snipping Tool just ain't cuttin' it (lol pun intended).

like

I really need some help.
What shortcut inverses my
Ctrl + [ aka Ctrl + {
which jumps through a cell to the source? How do I jump back? Manually isn't practical for a 50+ tab sheet

like

Hey Geniuses! I apologize in advance if this question has been asked before, I'm new here and just trying to learn as much as i can. Does anyone know a great source to learn Macros for beginners. I would like to create one for work. I appreciate it

like

Can anyone help me with this pls? I created a graph using data above (not shown) but for some reason “technology” here appears three times. I want sectors to be grouped together. Is there any way to fix this?

Post Photo
like

Our system is really lacking and we do a lot of work outside of it to track data. Currently I’m using Excel to track data from multiple resources, however, it’s so manual and prone to error. Any suggestions to keep the data clean when I have to pull info from multiple places? I’m constantly auditing and we won’t even look at getting a new system until next year :(

What are the most typical models you all build

likehelpful

Best pdf to excel converter?

like

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

like

Anyone know if / how to have the CapIQ and SNL (MI) excel plugins running at the same time? I always run into issues with one of them not functioning when they’re both enabled

Has anyone encountered this error before? We can’t access a workpaper with 70% of the work done 😩😩

Post Photo
like

Hi! I have knowledge of pivot tables, vlook ups. But I'm rusty on if statements and would like more knowledge on excel formulas. I'm looking for excel classes to take online. Any suggestions?

like

Can you share the most useful formulae and built in automation features you have used with the latest version of excel?

like

What's the F4 analogy in Office 365?

like

Is Macabacus or any other add-in actually worth it for Excel & PPT? In LMM - MM M&A roles.

likehelpful

Just created my first macro! Super proud of myself! #humblebrag

likeuplifting

Please help. I was recently hired by a Venture Capital firm that uses MacBooks instead of PCs. I’m extremely efficient with Excel on PCs and am struggling with the transition to Mac. Do any Mac users have a list of keyboard shortcuts that they use frequently, or any other tips/tricks?

likefunny

A lot of the work at my new employer is quite redundant and can be automated via macros. What are some of the best resources to learn vba?

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