I have a TB that came in as a table. Column A is the account number and the sub account is a top row, with the value for each account: sub account in the table. I’m great at excel…just not sure what formulas to use to extra it into a tb. Any ideas?

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

Couldn’t post this for some reason.. try this

Post Photo
like
Post Photo

Search Google for how to flatten or unpivot an Excel file. The Journal of Accountancy had an article on this several years ago.

like

Glad it worked! I had to use it several times to reformat data we received from clients about 5 years ago, but now my staff uses Alteryx to do this.

like

Torows, tools, etc ... Chatgpt is your friend; dynamic array formulas are also your friend

like

I don’t understand the ask, can you explain a bit more/better?

Unpivot through power query

like

I really don’t understand… please explain more

Post Photo

Related Posts

Hotel or corporate housing? Benefits and drawbacks of each. This is for a long term engagement in Denver. I really like getting my Marriott points, but wouldn’t mind staying some weekends in Denver.

like

Hi all, i would like to introduce myself. I am new graduate of mechanical engineering (UK). Looking to enter the industry. It been really difficult for the past couple of month getting a job. I would really appreciate , if i could get referrals from people in Engineering companies or tech companies. i could work for. I am not tied to any country however i would need a visa sponsorship. I am always ready to learn and very enthusiastic. I would really appreciate. Thank you all.

like

While applying for a job after drawing one month salary in current company should I mention the current company in my resume? I'm ready to freshly negotiate based on previous CTC

like

The nail on my second toe hasn’t been the same since I ran a half marathon a few years ago. It’s gross and totally messed up and it doesn’t seem to be getting any better. Do I see a podiatrist for toenails or a dermatologist?

like

After HR discussion after how many days Hr release offer letter?

like

Anyone with experience getting an ESA (emotional support animal) letter? Please dm me thank you.

like

Hello All,
Anyone having vacancy in Network Security or willing to refer in your organization? I have 10.08 years of relevant experience and currently working at Coforge, Noida.

Greatly appreciated!

like

I got canned today, so what should I pour for my toast to new opportunities?

Post Photo
like

So I had 3 deals scheduled to either close end of May or mid June which were all pushed to end of June/beginning of July. Which is when I have my first vacation planned for over a year (I take 0 time off). My whole family is flying up and we’re renting a cabin near me. What do I do? I’m running one of the deals, semi running the other one and not doing much leading on the other one. Note: I was supposed to not be running any of these. Do I find a back up first or tell the partners first?

like

Hi, I’ve been working in professional services and pre-sales so far but I’ve been planning to make a switch to product management. Does anyone have any similar experiences or advice?

like

If you like CIA type shows (Homeland but way more cerebral and real) try The Bureau (French with English subtitles on Sundance. Can get for $6.99/month (one free week if you want to crazy binge) on Amazon Prime. Am into Season 2 (5 Seasons) and loving it.

like

Hello Fish Friends! Does a PhD count as project management experience?

like

Hi folks,

I have been selected for the role of Senior business analyst and below is the salary Structure. Please guide me on how much more I should ask for?

YOE- around 4 years
Current CTC- 4.5L considering variables

Post Photo
like

I am down $25K on $150K portfolio. Should I cut losses and leave or continue :(

like

Hi all! Just got my perm approved woohoo. Filed in December. I know next step is I-140 and adjustment of status. How fast does this go? When will I hold a green card

like

I'm a master's student at U of M pursuing graduation in Engineering management. I'm looking for summer internships in business development and Marketing domain.

I have an year of experience in project management domain and I have managed 2 projects of around $55k and $80k.

I'll be grateful if someone could help me or point me in some direction.

like

Is it okay if I ask my interviewer from the first round tips for the next round of interview/format of interviews? They’re a school alumni.

Trying to get a second job does anyone know how this works. It says part time but the schedules looks full time some help please. Thanks

Post Photo
like

Additional Posts in Excel Genius

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

I’m trying to learn more about Excel functionality and there’s several simple functions that I don’t know, this is probably one. If I am color coding data, is there a way to automatically move those lines to the top or bottom of the spreadsheet once the color code for the line is made?

like

Our Data is only showing when something has changed, is there any way to make excel fill in the values?

Post Photo
like

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

How do I compare two sheets to make sure they are identical?

like

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

like

Hey fishies, looking for some help with the below

I have 4 lots of data categories which are assigned a code in the adjacent cell
Eg:
Cell A2= 'xyz' Cell B2 = 'w1'
Cell C2= 'ghi' Cell D2 = 'x1'
Cell E2= 'plm' Cell F2 = 'y1'
Cell G2= 'mhn' Cell H2 = 'z1'

The combination of the 'W','X','Y' and 'Z' codes identity a specific trend
I am extracting data which includes multiple combinations of these codes. What is the best way to show frequency of the codes against the category it is assigned to

like

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

like

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

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

Scan your QR code to download
Fishbowl app on your mobile

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