Hi. I need some power query help. I’m importing data from a 100 page PDF file. Power query views the PDF as 100 different tables each with four columns. I want to append all of these tables into one. The problem is, before I append the tables together, I want to stack the columns in each table, so that for each table, columns c & d are stacked onto columns a & b. Help how do I do this?

Hello

I've been interviewed by @Amazon on 8th July and even after multiple follow up emails, there's no update. Any suggestions?

In terms of taking the next step to elevate your career- what items are you heavily focusing on? I have speciality in data governance as well as product counseling, but curious to know what others find most helpful in their practice areas.

So abhi diwali gift bangaya ltimindtree gift.
Seems We get advantage club link to select gift of our choice. Same link provided for welcome gift also. Probably one more bottle and cup coming up

Hi Fishes, need your help.
Can anyone tell me the exact role for Quality analysis in Accenture. Thanks in advance.

Should people be fired for lack of people skills?

Hello Fishes,
I cleared the Level 2 interview as an Appian developer. Could you please let me know what Level 3 interview would be about? Thr HR said it's an interaction session with the panel. But should I be prepared technically?

Has anyone ever successful negotiated there salary with the federal government. I have tried twice and both times was cited a HR policy saying my specific circumstance did not allow negotiation. Just wondering if it’s even possible

Going from 165 as an ACD to 210 as a CD? Is that about right?

Hi, currently i am working with icici bank in backend operations in CIB team as Deputy manager but i am looking for an opportunity in Accenture can anyone help with the openings or referral??

What are some tips or recommendations on where to start to become a product manager? Much appreciated

Hello! I’m going to BSchool in August. Any recommendations on books / websites / videos to be more prepared for management consulting interviews?

Thoughts on Roland Berger Middle East?

Big 4 Consulting interviews: do most people fail out of interviews at the behavioral interview part or the case interview part? Does anyone know statistics of job offers given once you make the casing portion of a Big 4 interview?

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.

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”

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

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

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

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

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.

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)

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

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

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 🙏

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

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

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.