What is the best way to create a list of data from chunky, randomly spaced cells?
Example:
Supplier# PO #
Receiver# item quantity amount

Except there are a ton of random empty cells and some of these chunks of information (all in different cells) are longer because there are more receipts

And I want to put the Supplier # & PO # next to each receiver instead of above a bunch of them.

Hello, looking for a bit of advice. I have applied to about 30 positions in the last two weeks and have not gotten any interviews. I have 7 years of military supply chain experience, plus a year and a half outside of the military. I am an inventory control manager currently, and have applied to positions like demand planner, supply chain manager, supply planner, and other manager positions. Any advice on how to correct my job search?

Hello! Need hearts to unlock my DMs! Thank you so much 💛🙏🏼

What is up with the groups of cars that drive around the Loop with their warning lights on honking their horns? Anyone know what that is about?

Do I go for a promotion even though I’m being told it isn’t a home run? Is there a backlash/ detriment to declaring for one and not receiving? Would I be wasting folk’s time? This is my first run at a promotion outside the Army.

Thoughts on Pfizer’s canvas for developing emails and iDetails?

Anyone else experience of a lack of passion for the job in this Covid world? I just feel like I’m excited about what I’m teaching because so many techniques are not at my disposal. I also feel exhausted by the mask. I’m all for wearing them, but wearing it all day drains me. Any helpful ideas to reignite the passion?

My mental health has suffered tremendously over the past month. I have a therapist that I probably should see more of but I’m jobless and need to save. I am an aspiring entrepreneur with an inspiring business idea (to me lol) but my anxiety and depression is hindering me severely… fuck my brain. Any other founders here? It’s f‘ing tough.

please help me get to 11 likes to unlock the messaging features. Thanks a ton in advance 😊

Hi All,

I'm facing error as "employee ID is not available in BGSW user list" while registering in associate arena app.

Please let me know how to fix this error.

Thanks in Advance.

ZS hiring for multiple roles... DM in case of any referrals!

hi, I recently joined a strategy group and have only worked at IBM. I am curious how the strategy planning process works in other technology companies to compare to my own experience. wondering what is similar vs diff for this line of profession across the industry. can anyone share their company’s general process, timing, duration, who’s involved? thanks!

Transitioning from line of business familiarity (understanding financial statements) to... real(?) Finance (bonds and cap markets and other debt sales) any advice on books or resources to learn really from step 0?

Is an MBA really worth it?

What does an online MBA look like in terms of class time, work load, realistic time to complete etc?

Looking to book one night at a Marriott property in chicago to celebrate anniversary with my wife - mostly deciding between the Gwen and the Ritz. Which would you choose? (Assume price doesn’t matter)

I just earned my Masters i. Health administration and i am looking for a nursing home administrator in training positions in thd state of ohio; in order to obtain my license.

Looking to pivot my career and explore opportunities in the tech world, specifically in product management. What are the best Product Management courses/programs available?

I want to put together a XD file with a whole bunch of helpful web and app components for other designers to just drag and drop. 1. Is this a waste of time due to the market being saturated? 2. Where do I sell it? 3. Is there anything I need to know first?

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!

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

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

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

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..

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

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

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?

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

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”

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

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 ...

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

Any book recommendations on excel modeling for real world business applications?

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.