pivot

Sorry for the uninformative title; I'm not sure what to call the thing I'm trying to accomplish. I'm importing data from a PDF and hope to rearrange them into a more useful structure. I have a list of widgets, grouped by the subwidgets they're made of. So the initial import looks something like...

Hi I have the following picot table which I want to visualise as a Pie chart with a breakout bar chart. I want the Pie Chart to show Low, Medium and High and then have a breakout bar chart showing the Account Names that make up the High clients. Here's my pivot table Which is based off of...

Hello everyone, As part of the Olympics celebrations, we've created a couple of trivia quizzes using MS Forms for colleagues. Each MS Forms quiz outputs the results into an excel spreadsheet. From the outputted spreadsheet, the main info I need are: Name The points The amount of time each...

Help? We are moving records from one provider to another and their downloadable information is difficult to manipulate into a format suitable for import, and rightfully so. (Can you say Job Security?) But we ARE moving. Please see attached image. The data is paragraph-like...

Good Morning All I have raw data that contains 0's in the price per gallon field (first image. 0 record is first) Second image shows pivot table with a 3.017 average (this includes the 0 value record) Third image shows what the average is not including the 0 value . formula used is...

Hello there, I am new working with Excel data models, and I would like to know if is possible to do the following: I have a table that lists elements by boxes. Box type 1 contains elements 1,2,3,4: box type 2 contains elements 2,5,7,9; Box type 3 contains elements 2,4,6: Box type n contains...

Hi I have a set of data where I like to collect all data like in a pivot table but I like to choose as follows Project no Project sub The city will be related on country. So only cities related to country are visible in the drop down menu I have tried with power pivot, but I don’t quite...

Hi, I need to update pivot tables in a certain order, can some help with this? The data is on a tab called Details, on this tab I have a from/to date range and a refresh button The first pivot table is called Helper Pivot The second pivot table is called Pivot, which pulls data from both the...

In my pivot table, I created two columns using Show Values As: % of Column Total. One is Dollar Share and the other is Dollar Share YA. How would I calculate the difference between the two columns and have it appear in a separate column titled, Dollar Share Change? Since I calculated them using...

Is it possible to create candlestick chart from a PivotTable? I just can't find out how to arrange the data to be able to create a candlestick chart. I only get "You can't create this chart type inside a PivotTable". I have the PivotTable connected to a database connection and it would be...

Hi I am facing this problem I have the daily work score of 100 candidates for Jan, Feb and so till Dec. I want to find their average score for each month like Jan, Feb ..... The Months are arranged in rows and the candidates are arranged in columns Now when I want to create an average using...

Hi Using PowerQuery I want to transform the first table into the second so that every 'Number' in a 'Region' shows every 'Location' in that 'Region', with multiple rows per 'Number'. This is just dummy data. I have tried doing this with pivot/unpivot but struggling to get my head around it...

Hi I want to use Power Query to pivot a set of data, but instead of the value cell being a number, it is text. I need to turn this: into this: This is just an example of how the data is setup, using PQ does work for this data, but when I try it with my actual data I get the...

Hi all, So I have a table similar to the below which acts as a matrix, so Req ID 1 is in F1 but could be in any number of Fx, up to about F80. The status of a Req ID can be updated The Team X is the team who is interested/working on the particular Req. Req ID Status F1 F2 F3 F4 F5 1 Agreed...

I am not sure if this is possible I have this table: Is it possible for me to paste this table into value, allowing me to edit the numbers for T0 and T1, while still maintaining the subtotal/grandtotal formula? Something like this Thank you so much for the help The imgur is just a quick...

Hi, I have table queries which are appended into one query. see below I have a sheet which some fields are taken from above (some not shown here) see below Columns 1 - 3 are Pivot Table fields Merged cells in merged column 4 is formula cell - The result of the formula will show text of the...

Hi All, I am building a data set from a download of data from our Reporting Tool. To ensure the data reconciles: - For 2023 Plan I need to take All Country Data - For Actual reporting, I need to exclude one of these My Question is - How can I build a Pivot Report based on the whole data, with...

I was asked to keep track of a project and need to report on its progress every month. The raw data will be names, office locations, current model assignments, new model assignments, and the date the new model was reassigned. Initially, I was going to create monthly tables based on this data...

Hi, I have multiple data series provided from a source in a format similar to SeriesName1 NameTitle DataPoint1Title DataPoint2Title DataPoint3Title Person1 DataPoint1 DataPoint2 DataPoint3 Person2 DataPoint1 DataPoint2 DataPoint3 etc SeriesName2 NameTitle DataPoint1Title DataPoint2Title...

Hi everyone I've got an excel sheet with data sourced from PowerBI which is utilised daily however, I'm having to click "Refresh All" under Data every time i use it. Is there anyway to automate the data refresh? The PowerBI data is updated once every morning, if I could align my data to...