Convert Cross Table To List Excel

The tables produced with this style look more like the tables you can see in the books, scientific articles, and newspapers. It is not too complicated to implement, even if someone is not familiar with VBA. These functions help you to work with arrays of data, and are particularly useful when you need to cross reference between different data sets. Given Excel and Power BI are both MS products, I would have thought it would be obvious and straightforward to provide an 'Export to Excel' option in the File menu in PBI Desktop. An Excel list supports a variety of format capabilities including several built-in color schemes as well as the. There is a table called Employees that includes a field called HireDate. Convert 10kW to metric horsepower: P (hp) = 10kW / 0. Collaborations and file sharing are supported as well. Use your mouse to select the cells that contain the information for the table. No file loads better into Excel than an Excel (. Lets’ call this function as Split1. Not an Excel Pivot Table, but a VBA routine generating a cross-tab, looking like a Pivot Table (well, more or less). Many of Excel’s features, such as PivotTables, Charting, AutoFilter, and the Subtotal feature, were designed to work with flat data. Power Query will automatically turn your pivoted data into an Excel data table and launch a Query Editor window. How to create a pivot table. Re: Help converting cross table to list rbis84, However, i have just noticed that your latest bit of code is putting the "planned" value in the value column for both planned and worked data rows. The default location for a new pivot table is New Worksheet. Plan: spt_values. However, table will be more readable. Use these techniques to create dynamic sub-lists and custom reports that will match almost any report writer. Diagrams don't always start in Visio. I am attaching another file in which there is a tab for "crosstab" data and one tab for "flattable" data. Let’s start with a simple table like annual sales numbers for the current year. The main problem with people using excel is that they want to create outputs ( Final reports) instead of learning on how to work with data: Data needs to be tabular with rows and columns and not a single cell empty in the table. Visit [my Excel home page] [Excel Onsite Search] [top of this page] Presentation in HTML format by David McRitchie Appreciative comments should be directed to Bernie Deitrick mailto:[email protected] Clicking the Format as Table command button opens its rather extensive Table Styles. Excel COUNTIF Function – How to Use As the name suggests Excel COUNTIF Function is a combination of Count and IF formula. Displays an xls, xlsx, xlsm, xlsb (Excel), csv (comma separated values) or txt (tab delimited) file on Google Earth. Check the boxes of the cells you wish to include in the pivot table. So you have a comma-separated list, and now you need to insert it into the database. When one drags the part codes (alphanumeric string) column to the data area, count of part number would appear instead of the actual part number. From the pop-up menu, select "Save As". hi gang, I'm on v 47 and i was using fm kcd_excel_ole_to_int_convert. I am trying to convert a crosstab query to a table. This will add it to the list of available add-ins. Select Convert Text to Table from the drop-down menu. 0 is for Excel 2003 Please post the results on the forum and mark as helpfull the answers that have helped you, if you get no solution, please post again for us to continue. There are several scenarios where the INDEX function can come in handy when working with Excel. We can now open the Excel file and see the seperate tabs for each ODS table. Code: Assets01/09 Reversal of a crosstab table to a list. 1 inch is equal to 25. These types of queries can present a large amount of summary data in a format that is usually simpler to analyze than viewing the information in a database form. JSON_VALUE function will take id on the path $. One of the uses of MS Excel is to easily and quickly create fill-in forms. For amortization formulas, I think the best way to understand the equations is to create a loan amortization schedule or table to see what is actually going on from one payment period to the next. It works like a charm!! Thank you so much! R. How your mobile number or email address is used. Join the Excel Tactics Newsletter for the latest updates and articles. This actually helps you to calculate faster in excel. How to create two advanced dynamic lists in Excel. To refresh all pivot tables at once, you can use VBA, refresh button or pivot table options. Original Data: x y z a b c Desired Outcome: x y z a b c Is there a formula I can use? I don't care what order the resulting list entries are in. Convert a table with counts to a matrix or data. Power Pivot for Excel lets you output a variety of visual data to your Excel worksheet. Just click the menu, and select the table. To summarize, the query will not show up in Excel's Select Table list while RegSales is part of the Net Income column. with all 3 names separated by ",". We have added five simple methods to insert tick mark (checkmark) or cross symbol in MS Word or MS Excel. Solved: Hello Team, I am loading the data from an a SharePoint list which is of the following format Division Application Functional. Access VBA DoCmd. Let's conduct a dollar-to-euro conversion, for example. Actually, converting contingency tables to data frames gives non-intuitive results. Fahrenheit (°F) to Celsius (°C), how to convert & conversion table. A wizard makes the "match and join" process fast and easy. Then it will render the data in 3 columns as a regular database data table. Welcome to 123PPT PowerPoint Tips and Tricks for PowerPoint, Word, Excel, and Microsoft Office. Enter the value to convert from into the input box on the left. It is important to understand in tables because it can be particularly tempting to apply things like backgrounds to the table itself or table rows, only to have the background on a table cell "override" it (it is actually just sitting on top). But the thing is, you need to insert each value in the list into its own table row. This collection of awesome tips and tricks will help you master pivot tables and become a data ninja!. There is an implied vertical stacking of table elements, just like there is in any HTML parent > descendent scenario. Some historical sets are reported as summary tables of counts in a limited number of bins. Please do not post your question in a thread started by another member. Features and Commands in Microsoft Word 2010 Menus and Toolbars. Here's a look at why you. 1- Open an empty excel sheet, and in the Power Query tab, In the "Get External Data" section click on "From Other Sources" and then choose "Blank Query". with all 3 names separated by ",". If you are sending a report to someone without its source data then it's better to convert all the formulas into static values. Let's learn how to use Power Query to unpivot data. Confirm the selection and if it has headers. Then there are three more columns for each of the five products being sold. Display main category and sub-category in a drop down list in Excel. Preconditions in Windows. This actually helps you to calculate faster in excel. Click the Workbook Appearance command, then click Toggle Filter Grouping. Using Stuff – Learn more on the SQLServerCentral forums. Color code converter. choose fields from the Pivot Table field list. Excel pastes the data into several rows. One of the uses of MS Excel is to easily and quickly create fill-in forms. frame representing those counts. Then it will render the data in 3 columns as a regular database data table. In this Excel tutorial from ExcelIsFun, the 538th installment in their series of digital spreadsheet magic tricks, you'll learn how to create dynamic sub tables based on master sheet array as well as how to create array formulae quickly with the Drill-Through method. Under Pivot Table Fields, the Active button is selected because. This makes it far easier to produce a sensible query plan. Calculate cross-section and conversion factors for cables and wires. The task is to convert this pivot table data layout to the result shown in the "Desired result" sheet. We took a look at the feature back in Excel 2010 , and in Excel 2016 we continue our look at how you can use it to manipulate and find data trends. After you create an Excel table, you may only want the table style without the table functionality. frame are not available for table (e. I'd like one column for the "Week Commencing" and one column for the "forecast" (see attached file). So we will create HTML text for the data table and then save it as a. The solution will also work for the Mac 2016 version of Excel. There is an implied vertical stacking of table elements, just like there is in any HTML parent > descendent scenario. For example, we used the "minimal" style and we can look at the ANOVA table in the second tab for an example of this style: To see a list of the available styles, run the SAS code below:. How would I go about automating the conversion of a very long list in a format like this: Into a table like this: I am using Microsoft Excel 2010 on Windows because of the layout of my data as seen in the image, the pivot table wizard is not recognising the fields. Exchange rates for the US Dollar against foreign currencies from Europe are displayed in the table above. org for the content. Cross tabulation involves producing cross tables also called contingent tables using all possible combinations of two or more variables. Excel will automatically load the new. If you create the same in Excel 2003 or earlier versions, the orientation would be slightly different. In this lesson students will build quarterly worksheets, a summary worksheet, and a chart worksheet using previous learn skills with excel. While converting a time from one format to another, there is no need to convert minutes. With the latest update of Power Query AddInn for Excel quite a few new features were introduced, but none as sweet as the new Pivot option. Create Table data as Native CAD Entities from Excel Speed up your CAD Processing: This website is dedicated solely to provide you with lisps to simplify and speedup your Survey Drawing Preparation. Volume Conversion Table. Check them out below. How to convert KML to XLSX with Microsoft Excel. You may also want to read: Access Crosstab Query. 10 reasons to use Excel's table object. Using Excel Pivot Table, it is easy convert data into a Matrix Table with the help of Aggregate Functions such as Count, Sum, standard deviation. Excel table to flat list. That adds a email header to the work sheet and you can send directly from Excel, no pasting. ), and put the value into column 2. These types of queries can present a large amount of summary data in a format that is usually simpler to analyze than viewing the information in a database form. To convert the list to a table, I clicked TransformTo Table, then gave the new table a column name. After you create an Excel table, you may only want the table style without the table functionality. com Say you have a table of data and you need to get a set of unique values from a column of the records. This is done by Insert > Reference > Cross-reference Select on of the captions you have created from the list in the dialog and click insert. I call it the “1 Minute Drop-Down”. Diagrams don't always start in Visio. Our conversions provide a quick and easy way to convert between Length or Distance units. Accurately convert PDF tables to Excel Free up hundreds of hours of work with PDFTables. Custom sort order. Many solutions have been implemented to read Excel files from R: each one has advantages and disadvantages, so an universal solution is not available. Click Finish to create the pivot table: Drill down (ie double-click) on the intersect of the Grand Totals (here Cell V7 or 7): The PT may now be deleted. Displays an xls, xlsx, xlsm, xlsb (Excel), csv (comma separated values) or txt (tab delimited) file on Google Earth. If you opted to. Exchange rates for the US Dollar against foreign currencies from Europe are displayed in the table above. Flat data is described as data which contains values in all cells within the table. Each Row represents a specific date. Each row represents a different city, and each column represents a different. Categories. In excel go to Tools – Data Analysis. org for the content. Have you ever wanted to create a drop down list in Excel to avoid data entry errors or to make the data entry process easier? In this post I’ll cover a whole range of tips on how to work with drop down lists in Excel including: How to create/modify drop down lists Create lists using information […]. Excel 2007 made a formal object of the informal list and called it a table. It is fully compatible with the MS Excel file format, and you can import and export Excel document to and from Zoho Sheets. Hello, I have data in cross-tab format which I'd like to convert into a list, e. Flaws, bugs, traps, code, design. Be sure to use Word functions to add captions and cross-references to the plots and tables in your report. Note that at this point it is “just” a list, not a table. We took a look at the feature back in Excel 2010 , and in Excel 2016 we continue our look at how you can use it to manipulate and find data trends. In the case of a multi-statement table-valued function, these T-SQL statements build and insert rows into the TABLE variable that is then returned. One can position the table itself, and all contents in a row, and contents in a cell, but not with a single parameter for all contents in the table, see m:Template talk:Table demo. transposing, rotating, copying and pasting can give you what you want but it will take a long time. Easy to use online maths calculators and solvers for various topics. while all the data fields work correctly when it came time too upload text, defined in my abap as char 400 only 32 chars are passed in the intern table, the defination from the KCDE_CELLS structure for value is only char 32 which seems small Is there away around this or. If you'd like to follow along with me in this tutorial, I've made the sample data available in this free Excel file. In this tutorial, I’m going to show you: The 5 steps to create a drop-down in 1 minute or less. table and is. Click "Generate" button to see the generated table's LaTeX source code -- select it and copy to your document. By specifying DBMS=EXCEL, the SAS export file can read any of these versions of files that are saved in Microsoft Excel workbooks. You can then instruct Excel to relate data to each other using a common column. How to Convert a Row to a Column in Excel the Easy Way Lori Kaufman @howtogeek Updated September 28, 2017, 5:33pm EDT You've set up a worksheet, when you realize it would look better if the rows and columns were reversed. You can search forum titles, topics, open questions, and answered questions. Confirm the selection and if it has headers. Ensuring that Word TOCs create Hyperlinks in Acrobat Not long ago, I received the following email from a large law firm which was creating some internal documentation: I am having trouble converting a Table of Contents in Word to PDF so that all the hyperlinks work. Then, add the. Merge and extract data from two or more tables. Ask Question Can't create a scatter chart from a pivot table in excel. A list of values for column2 to pivot into headings in the cross-tabulation query results. To view the file, you will need the Microsoft® Excel® Viewer available for free from Microsoft®. How to add a Checkbox in Excel: As I have foretold that checkbox control is present in the Excel developer tools. They need this big table so that Pivot Tables can source a single table. Go back to Pivot Tables to learn how to create this pivot table. The ability to quickly group dates in Pivot Tables in Excel can be quite useful. Opioid Conversion Table be reduced by 25-50% to avoid unintentional overdose due to incomplete cross-tolerance and individual variations in Convert each dose into MMEs by multiplying the. Online calculator to convert inches to centimeters (in to cm) with formulas, examples, and tables. Next, drag the following fields to the different areas. Type a comma to move to “table_array. These examples will make it easy for you to understand how one time format can be converted to the other. Beyond this, if you have the detail data that you want to simply add to the workbook after ODS EXCEL CLOSE, then you can use PROC EXPORT -- one step per set of data that you want to add. Completely freeware. Next, click any cell inside the Sum of Amount2 column. The same Unpivot Table option is available in Excel 2016, but it creates a new table and fills it with the values without any link to the source. I have found the VBA code online but am unsure how to tweak it to get what I want:. Tara is working on a database that holds employee information. Cross tabulation involves producing cross tables also called contingent tables using all possible combinations of two or more variables. It is relatively easy to convert a table to a similar formal structure without a table. In this post, we played with C# Array, DataTable and implemented to convert row to column and get Pivot Array, DataTable and List of dynamic object. Formatted tables are easy to set up, and make it easy to sort, filter, format, and expand your list. Our conversions provide a quick and easy way to convert between Length or Distance units. Data editing must be done in the Excel worksheet. To show your numbers in thousands, highlight them, right-click, and select Format Cells. This is done by Insert > Reference > Cross-reference Select on of the captions you have created from the list in the dialog and click insert. Confirm the selection and if it has headers. What I have done is remove the grouping that the pivot table applies and ensured that I have the relevant week number, project and department details against. Features and Commands in Microsoft Word 2010 Menus and Toolbars. In the next few steps we'll show you how to convert them into an Excel Table. frames representing the original values is useful for pedagogical purposes. This is one of the Rules you agreed to when you joined the board; and explain your issue fully. Census Bureau's North American Industry Classification System (NAICS) and Standard Industrial Classification (SIC) Codes and Titles database. Mynda: this is a Great article. Real-Time Excel - get live stock prices, currency rates and more includes working spreadsheets for this tip and many other examples of getting live information into Excel. First, we need to ensure that our crosstab data is stored in a table. An Excel list supports a variety of format capabilities including several built-in color schemes as well as the. Power BI is really great in making sure to have a Cross Table in Exce 2016 which is easier to do claculations and unpivot the same table in Power BI with link to the source table. How to import Microsoft Word documents into PowerPoint and how to import Excel spreadsheets and graphs into PowerPoint. The pivot table links to a larger table from which it gets its data. In this Excel tutorial from ExcelIsFun, the 186th installment in their series of Excel magic tricks, you'll see how to extract records that meet two conditions (criteria) and list them in order with no extra rows between records as well as how to create a formula to extract part of a table from a larger table based on two criteria. 3) Sheetster. Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers. The Data table looks like this:. Dependent Drop Down list is also known as cascading data validation, and, it limits the choices in a drop down list, depending on the value selected in the other cell that contains data validation. Open the Excel spreadsheet. There may be times when you want to use the strikethrough command to show that a word was edited or exchanged for a new word. This symbol indicates a link to a non-government web site. Quick Data Prep Trick: Use a Flat Pivot! data in a tabular form and the answer was the new Excel 2010 flattened pivot table that Kasper and Rob have blogged about. In this format, the hours are listed from 00 to 23. It looks very similiar to a normal excel pivot table at a first glance but there are a few differences between excel cube and crosstab: - The greatest advantage of an excel cube over a simple crosstab is that the data is stored externally in a. Standard SMS rates may apply. Tableau for Excel Users – Part 1 – Recreating the pivot table. And, today, in this chapter, we will show you how to create Dependent Drop Down list in Microsoft Excel, using different methods. Create Pivot Table From Multiple Worksheets In order to try an example of Creating Pivot Table using multiple data sources, let us take the case of Sales data from two stores (Store#1 and Store#2) where the data is located on two separate Excel Worksheets. This is a table that is used by internal stored procedures for various purposes. One of the uses of MS Excel is to easily and quickly create fill-in forms. How to quickly convert an array table to a list table in Excel? Supposing you have an array table/cross table, and to convert this array table to a list table may be not a difficult job for you and you can convert it by entering the data one by one. In SAS it is created using PROC FREQ along with the TABLES option. Cross Validated (stats). In such scenarios, this post would be helpful to achieve the goal. (4 replies) How can I add an excel file with *. This so I did not acurally look at your derived table, but. ProdOrd)) AS CountOfProdOrd SELECT [HOUR. If you don't want to create a named table, you can follow the instructions in the named range section below. Launch Excel 2010, and create a datasheet on which you want to link checkboxes with different actions. Re: Macro for converting Crosstab data into a flat table Hi royUK! Thanks for your reply. After you choose the rows and columns for your cross-tabulation, you indicate what piece of data you want cross-tabulated in the pivot table. As you can see the lines with equal length and layer show only once in the table, with a count of 2. Click "Generate" button to see the generated table's LaTeX source code -- select it and copy to your document. Convert this new series to an XY type, and then assign it to the primary axis (if Excel moved it to the secondary axis). Related Excel Newsgroup articles: inputting symbols (this article not found 2000-05-29). … Legal Office Guru has a short and simple video tutorial on [this feature]. The name of each field is in the list's first row. The SAS LIBNAME engine recognizes EXCEL97, 2000, 2002, 2003, and EXCEL2007 as aliases for the identifier EXCEL. SQL-Server-2008. The file is attached. How to Convert a Row to a Column in Excel the Easy Way Lori Kaufman @howtogeek Updated September 28, 2017, 5:33pm EDT You've set up a worksheet, when you realize it would look better if the rows and columns were reversed. Welcome to 123PPT PowerPoint Tips and Tricks for PowerPoint, Word, Excel, and Microsoft Office. The Format as Table feature in Excel 2016 is so automatic that the cell cursor just has to be within the table of data prior to you clicking the Format as Table command button in the Styles group on the Home tab. External links for other issues that might prevent filter function to work properly. The output also works with the Calc spreadsheet program from OpenOffice. A "Create Table" dialog box will open. I would like to make a pivot table of exported values, but the application doesn't export the values of each period as a flat list but unfortunately as a cross table. The first thing I would do is then convert this table to an ugly list. into a table with rows of (activity, date, value) so that I could add columns for year and month and then analyze the data using a pivot table. To summarize, the query will not show up in Excel's Select Table list while RegSales is part of the Net Income column. The VLOOKUP function is a straightforward way to merge data in Excel. Excel can grab that data and put it into cells for the worksheet. It turns out that you can do this with another pivot table, yay! I followed this tutorial to convert my summary columns into data rows using Microsoft Excel 2010. Excel will navigate to the table, even if it's on a different tab in a workbook. 0 Convert Lotus Notes contacts to Outlook Express by SysTools Notes contacts to Outlook Express conversion Software which converts Names. Using PivotTables to answer questions. csv) file to Outlook Express with ease & convenience. Flaws, bugs, traps, code, design. Plan: spt_values. This formula looks like most formulas do in Excel, with cell references, as pictured below. The same Unpivot Table option is available in Excel 2016, but it creates a new table and fills it with the values without any link to the source. I am trying to get the 3 rows in the below in one line. Here's a look at why you. However, table will be more readable. Open the Excel spreadsheet with the data table that you want to copy by right-clicking on it and selecting "Open. Finally I would like Visio to generate a flow chart based off of this imported data. It also allows performing aggregations, wherever required, for column values that are expected in the final output. Once I figure out how to create it I will let you know how it works. How to convert KML to XLSX with Microsoft Excel. Limiting input to 1 and 0 makes it easy to use the cell in True/False fromulas. hi gang, I'm on v 47 and i was using fm kcd_excel_ole_to_int_convert. The above formula works great when you want to get a list of all the file names from a folder in Excel. Business Analysts can now visualize process steps and associated metadata in a structured Excel table as Visio diagram. Access VBA DoCmd. Use Excel's merge feature to extend a single cell across multiple columns or rows. Normally this type of pivot table is used for combining data on different sheets, but it has the side benefit of taking horizontal data and providing a vertical extract once you double click on the Grand Total field. Power Query is the best way to unpivot data in Excel. When prompted, select the table that you want to export. When you use the Vlookup Excel function to retrieve information based on a student name or a bank account number, you cannot allow it to find something close or similar to “Jake”, or close to the account number “3647463”, but rather it has to find them exactly. Welcome to 123PPT PowerPoint Tips and Tricks for PowerPoint, Word, Excel, and Microsoft Office. It extract filenames according to its original structure. Let's conduct a dollar-to-euro conversion, for example. Then, add the. to reflect any changes you make, such as…. Just want to share some simple code, witch we used to convert JSON to Excel file. In the spotlight: Export tables to Excel ®. Create Pivot Table From Multiple Worksheets In order to try an example of Creating Pivot Table using multiple data sources, let us take the case of Sales data from two stores (Store#1 and Store#2) where the data is located on two separate Excel Worksheets. So why would you convert it to a list? Because Excel is in love with lists. You typically create a pivot chart by starting with the Create PivotChart Wizard. If not, you’re missing out on one of Excel’s best features. When you create a list in Excel, do you automatically convert that list to a formatted table?. On the “Excel Options” dialog box, click “Formulas” in the list of items on the left. This Excel VBA tutorial explains how to change partial text color in a Cell using Macro. Length Converting Factors ;. PivotTable subtotal A row or column that uses a summary function to display the total of detail items in a PivotTable field. Start your own thread,give it a search friendly title that aptly describes your issue. Table of unit conversion & factor of Volume or Capacity. SQL ALTER TABLE. Apply Basic Borders to Cells the Help table of contents for that program is. There must be a formula in a cell already to receive the data. Current-carrying capacity: tables (Extract from VDE 0298 T4 06/13 tables: 11, 17, 18, 21, 26 and 27). This example teaches you how to group pivot table items. transposing, rotating, copying and pasting can give you what you want but it will take a long time. Check the boxes of the cells you wish to include in the pivot table. Display main category and sub-category in a drop down list in Excel. The tables produced with this style look more like the tables you can see in the books, scientific articles, and newspapers. It is important to understand in tables because it can be particularly tempting to apply things like backgrounds to the table itself or table rows, only to have the background on a table cell "override" it (it is actually just sitting on top). That adds a email header to the work sheet and you can send directly from Excel, no pasting. Join 20 million people and teams that organize, plan, and collaborate on tasks and projects with Todoist. Select makes DataTables act like small databases. The VLOOKUP function is a straightforward way to merge data in Excel. Conclusion. The temperature T in degrees Celsius (°C) is equal to the temperature T in degrees Fahrenheit (°F) minus 32, times 5/9:. Figure 8 shows the final report using fields from both tables. 2) Or instead of a query table, use either ADOX to read the header names, or, and it might be simpler, plain old ADO to query the data – and again returning a small dataset if there is a lot of data – and loop through the fields collection, grab the last few headers and edit the SQL to suit. Here's a look at why you. We took a look at how to create cross-tab queries in SQL Server 2000 in this previous tip and in this tip we will look at the SQL Server PIVOT feature to allow you produce cross-tab results. The Linked Table Manager allows you to manage any linked table that you might have in the Access database. This example shows how to perform calculation on tables. In this lesson students will build quarterly worksheets, a summary worksheet, and a chart worksheet using previous learn skills with excel. On the Insert tab, in the Tables group, click PivotTable. are including. 09/19/2019 (19 responses) I have a list of products that need to be sorted in a very specific manner - the final sort order should be as described in the column title. Effectively, we need to convert a matrix like data layout to a tabular layout. We took a look at the feature back in Excel 2010 , and in Excel 2016 we continue our look at how you can use it to manipulate and find data trends. Original Question:-How to split a cell into 3 different cells? I am importing text file in Excel, but all data is importing in a column I want to split a column data into 3 different cells. I just can't seem to get my head wrapped around any explanation of them I've run across. The window appears as shown below: Save As option in Microsoft Excel; Click Browse to select a location to save the file. Creating the list of Figures To create a list of select: Insert > Reference > Index and Tables Select the "Table of Figures" Tab. Our linking to these sites does not constitute an endorsement of any products. The Data table looks like this:. Excel 2013 makes it easy to link tables, create reports and more. I have multiple tables (NOT pivot tables) which I send out for updates. Code: Assets01/09 Reversal of a crosstab table to a list. How to Reverse a Numbered List. JSON_VALUE function will take id on the path $. The GETPIVOTDATA function extracts the data stored in a PivotTable report. Original Data: x y z a b c Desired Outcome: x y z a b c Is there a formula I can use? I don't care what order the resulting list entries are in. It is just a different format in which you can express time. Convert Data Into a Table in Excel. Excel 2007 made a formal object of the informal list and called it a table. Convert two lists to tables, if not already done. Please do not post your question in a thread started by another member. You can search forum titles, topics, open questions, and answered questions. To stop working with your data in a table without losing any table style formatting that you applied, you can convert the table to a regular range of data on the worksheet. I want to reference one of its columns and COUNT the numbers in that column.