I'm trying to split one row into multiple rows in a table. The screenshot explains my ask best. In reality, I'm dealing with 1000s of rows, but the picture gets to the essence of the ask. Please let me know any solutions - most google searches are pointing me to text to columns, which isn't what I'm trying to do

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

Use Power Query delimiter function to break the columns apart first. Then use Power Query to Unpivot your columns so it would be in rows.

likehelpful

Awesome! Glad that worked out.

Is the example in column B a single cell or two cells with a blank boundary? You might be able to do a LEFT(B3,FIND(“[press Alt-Enter here to insert a return character]”,B3)-1); similar with RIGHT(...) to get the second value.

Then once you have all the values in different columns, unpivot and fill the blanks.

like

Do text to columns and then transpose paste? Then do an of formula to fill in the blank rows on tge left.

like

Do another column and put in a formula to fill out your missing cells in column A? If(cell=0 or isblank, cell above it, if not return that cell)

Related Posts

Dress code in TCS is formals all day week ?

like

what are the chances of getting fired at tcs for someone as lateral at 25l ctc associate consultant?

like

What is more beneficial for a SAP BWHANA guy to learn : Azure/AWS or SAP CPI?

Which tech stack has best chance of getting me job abroad?

like

Hi guys, I shall be joining PWC from EY. What should be the appropriate hike that I should negotiate?

like

Hello fishes, can someone tell me how many leaves we get every year, vacation/earned keave+ sick leave? Also how many can be carried forward to next year? TIA

like

Any advice for a failed designer who needs to pivot? I want to be a copywriter at a digital agency. Unsure what to do in the meantime.

like

Top EA horror stories? I could use a laugh - I know we all have one! Early in my career especially

likefunny

Hi fishes! 👋

Excited to be here on this platform as I Joined yesterday. 😀

Also, shower some ❤️ in order access inbox please!

Question on career: I have been working as a Configuration Business Analyst for a year now. Been learning SAP material master, SAP configurator, and CPQ now. Lot to learn on the way.

How should one map their career path from here like myself from here?

like

Salary range for digital account managers (Google ads/bing, SA360, DA360, Facebook ect) with 3+ years experience in Boston area? Approx. $1m budget mang. 3+ years experience. Moving out there soon!

Ekkuva mandi telugu vallu ye office lo vunnaru?

What kind of bonuses or Diwali gifts other companies are giving I am curious or tcs is only one who giving nothing

like

Fish that left consulting to become Product Managers/Product Owners. How’s the work life balance? Learning curves?

like

Is it mandatory to stay in the city you assigned to?

I talked to the recruiter, she said EY expect everybody to be in the city in September.

Even though your project is 100% remote, do you need to?

I got no relocation package so I have to think about this.

like

McKinsey Associate vs Google PM?

Don’t have offers in hand, but considering directions

funnylikesmart

Which healthcare/pharma/biotech companies offer remote working options?

like

Hey, apparently I need more likes to unlock DMs or something like that. Anyone know how many?

like

When should I update my linked in to my new job title? I start in a few weeks - not sure if I should wrote “incoming associate” so I can network with ppl before then? Just left my old company as well…

like

Has anyone dealt with stuffing allocation in a non-hedge fund context? It seems even in the HF world the law is fuzzy in using aggregate reverse 704c principles in stuffing allocations. Like, sure, the market is there but no authority really blessed it (other than some Cravath partner’s article in Tax Notes in 2013). If we are talking asset class that isn’t really like marketable securities but might be able to treat it similarly solely by virtue of, say, valuation on a quarterly basis (contd)

like

Additional Posts in Excel Genius

What’s the shortcut to move between tabs? I try ctrl+up or down and it just goes to the top or bottom cell

like

Need help tabulating survey results. Each row is a respondent, but the question asks “choose all that apply” resulting in several columns associated with that one question. How can I get a distribution for which answers were chosen among the top 3?

like

I rarely have to use formulas in Excel, so please be kind to me.

Apart from conditional formatting cells, what formula can be used to display a word whenever a cell contains a range of numbers? Contd

like

This isn’t exactly an excel question, but is there a way to clear the “last modified by” history on an excel document in SharePoint? Accidentally opened a file i shouldn’t have.

likefunny

Is there a way to add 3+ criterias into a vlookup and if there are multiple results, to list them in different cells?

like

Does anyone use XLOOKUP over Index Match? Why /why not?

like

Anyone work on a Mac and use parallels when in need of excel? If so, does it work or is it a big no-no? My work going forward will not primarily be excel, but I have to use it on weekly/monthly basis. Might also have to use some Power BI. Would love to go back to working on a Mac but excel has stopped me from buying one…

like

Is there a way to color a cell based on the color of another cell? I have Sheet one with green, yellow, red used to denote progression status on 20 tasks, which constantly changes based on client input. Sheet 2 is a summary dashboard of each of those 20 tasks. If sheet1 C3 is green, how can I get the respective sheet 2 dashboard cell to also turn green?

like

How to smoothen trendline in excel cell? Currently lines look crooked/pixelated.

like

This is the 🐐 bowl. No fuss and nonsense just all business

like

Hey!

What are the less known skills in Excel worth learning which are also high in demand in the market?

PS: I am starting off on Fishbowl so please support with a ❤️.

like

Hi all - quick (and sadly really urgent) question for my excel folks. My computer restarted yesterday evening, I opened the excel file I had been previously working on this morning and I noticed the developer tab was gone. I added it back via the toolbar but now in that same file some of the specific commands within the developer tab are greyed out and I cannot use them. I’m unsure why this is happening because if i open a blank workbook everything is available?

like

If D3 contains “YES”, how do you hide line 5? Is this even possible?

like

Mac iWork Numbers question: is there a GPS co-ordinates function? Looking to pull location information & calculate distances between locations in the sheet.

like

I truly appreciate this group.

Post Photo
likefunny

In a usage based ARR model, how would you build out the revenue model for an example customer: March, customer is new and generates 3k rev for company, April: $4k Revenue, May: $5k Revenue, Customer churns June.

From a quarterly perspective, how would you recognize the following? Q1 & Q2 New customer revenue, Q1 & Q2 Change in existing customer revenue, and Q1 & Q2 Lost revenue from customer churn.

I'm stuck on how to recognize Q2 change in revenue of existing customer, & Q2 revenue churn

like

Is there a way to easily create all the permutations of 315 possible combinations of numbers in excel?

like

What’s the best way to go about taking a massive data file (300,000 rows, 634 columns and turning it into something more usable? I’m familiar with PowerQuery and PowerBI and the end goal is to get all the data into PowerBI. It’s basically item attributes by item by store and sales dollars, units, and on hands from 2019-present by week.

like

Excel noob here. Can anyone help me write a formula where if a range (column) contains a particular value, then return a value in a different column of that same row into a cell?

like

I’m 26 y/o and working as a sales coordinator (basically an assistant) for 5 national account managers in the investment banking industry. I have a BS in Finance and am series SIE, 7 and 63 licensed. I’m only making $50k a year (before taxes). There are a lot of aspects I enjoy about my job but the pay is not cutting it. Recently, I have found a passion for working with data in excel and I want to try to make a career pivot into business analytics but not sure where to start. Advice?

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

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