excel pivot table independent columns no sub levels

Need help i want the excel pivot table to show each logically independent columns next to each other instead of sub level/nested.

Can create multiple pivot table but would be ending up having 10+. So is it possible and if yes how?

(tried google and videos but no help, so finally writing a post)

Image of how i want it to look is here : excel pivot table independent columns no sub levels


Category: microsoft excel Time: 2016-07-30 Views: 0

Related post

  • Need Excel pivot table independent columns and no sub levels 2016-07-30

    Experts: Need an help - i want the excel pivot table to show each logically independent columns next to each other instead of sub level/nested. I can surely create multiple pivot table but would be ending up having 10+. So is it possible and if yes h

  • Cannot sort Excel Pivot Table by two or more columns 2016-01-06

    I want to sort my Pivot Table by two columns. I've searched the web for some time, and it seems Excel doesn't allow this, so I need a workaround. My data Desired Outcome I want to summarise this by customer, sorted by number of orders, then total val

  • How to filter source sheet in Excel pivot table drill down? 2012-06-29

    I record my expenses in an Excel spreadsheet. In a second sheet I have a pivot table that allows me to group my expenses by month and by category to see the totals. If I double click on a cell, a new sheet is automatically added that displays a list

  • MSFT Excel pivot table links to external data 2009-08-17

    Question1: What is the best online forum to ask MSFT Excel questions of the following variety? Question2: How can I link an excel pivot-table to a potentially changing source table without having to re-draw the excel pivot-table layout every time the

  • Excel pivot table group all months by year 2011-01-25

    I have all my data grouped by year and then sorted by month (in an Excel Pivot Table): 2007 2008 January February March ... January February March How can I group this as follow: January February March 2007 2008 2007 2008 2007 2008 I've set the colum

  • How can I make an Excel pivot table from very large text file? 2012-05-24

    I have a text file with tab delimited columns, that is longer than can be imported into an Excel worksheet (> 1,000,000 rows). I'm trying to figure out how to create an Excel pivot table from the data in this text file. I'm not very familiar with piv

  • Linux alternative to Excel pivot table 2015-07-30

    My company uses some simple MySQL queries to generate a CSV report of a bunch of stats (about 20 columns, rows in the low thousands). We then use Microsoft Excel to create pivot tables to explore and drill down into the data. I've tried using LibreOf

  • Excel Pivot Tables - Divide Numerical Column Data into Ranges 2011-03-02

    I have an Excel spreadsheet with a column called "Time Elapsed" that stores the number of days it took to complete a task. I would like to make a pivot table out of this spreadsheet where I divide the "Time Elapsed" column into ranges,

  • Excel 2007 pivot table where columns are custom values not directly in table (sort of) 2011-05-07

    I have an Excel spreadsheet that has some survey results.There are 3 questions which can be answered on a scale of 1-5, i.e. 5 strongly agree - 1 strongly disagree. The columns are Gender and the questions, the rows are each respondent and each cell

  • Excel Pivot Table Date Range as Columns 2011-05-19

    I have the following data which I wish to pivot: Student JoinDate ReleaseDate John 01/05/2011 05/05/2011 James 02/05/2011 04/05/2011 I would like to create a pivot table which shows me a count of students within a given date range: 01/05/2011 02/05/2

  • Excel pivot table categorical variables the same in multiple columns (histogram) 2013-08-22

    I am relatively new to pivot tables, and there is one thing that I just can't figure out how to do. I have a worksheet that has several columns of categorical data. Each column (Groups 1, 2, 3) has the same type of categorical data, i.e. each cell is

  • Excel pivot table, difference between fields in the same column 2015-04-13

    I have table that has the same account names but for different years (sample below). I want to create a pivot item field that calculates the difference between the years for the same account name Account Name Year Amount Account 1 2014 15000 Account

  • Excel pivot table with the categorical variables in multiple columns 2015-07-04

    My data consists of a series of registers (patients) with some properties (Age group, Sex) and the result of four observations of the same categorical variable (Healthy or Sick): Subject_Id Age_group Sex Summer Fall Winter Spring --------------------

  • How to change Excel Pivot table column to text format for vlookup purposes 2014-06-03

    I have a column in my data that is ID numbers, basically. Made a pivot table out of the data. I'm trying to do a vlookup into the pivot that ignores the first number in the data like so: =vlookup("*"&A1,pivot table columns,2,false) But I get

  • Excel Pivot Table: Adding single column in grouped pivot table 2016-01-22

    Using a pivot table with this setup: Name Amount Total Jan Feb ... A 1 2 3 B 2 1 3 C 4 1 5 D 3 3 6 Total 10 7 17 The data is coming from a table where each "Amount" has a specific date (ex 1/1/2016, or 2/4/2016), these dates are then grouped by

  • How to group only some columns of the column field (Conditional Grouping) in Excel Pivot Table using VBA 2016-01-28

    I have created a Statistics Pivot Table using VBA containing EmployeeName as the Row field, Year as the Column field and Sum of Salaries as the Data field. I have to group the Years < 2000 (The corresponding employee salaries have to be summed up als

  • Excel Pivot Table or VLOOKUP 2011-06-11

    Students have an ID, Name, and English Level in one spreadsheet. They have an ID and achievement on a standardized test on another spreadsheet. I need to match the ID's and put the English level into the standardized test results. I was under a deadl

  • Excel Pivot Table - How to preserve Filter and Sorting when Data get refreshed 2014-09-05

    I have a pivot table (Excel 2010). Every Time when I update the data and make a refresh, the sorting and filters of the Pivot Table get lost repsectively I need to explicitely to modify the filter (select all, and remove the ones which are not needed

  • Excel Pivot Table Consolidation soing subtraction 2010-02-05

    I have one sheet for products purchased and another one that sold. I want to make a pivot table from two sheet to get current inventory for each product. But options are only sum, average etc there is no subtraction. How could I do that? I am using E

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development


Front-end development


development tools

Open Platform

Javascript development

.NET development

cloud computing


Copyright (C) avrocks.com, All Rights Reserved.

processed in 0.586 (s). 13 q(s)