Subscribe Bookmark RSS Feed

Can we flip a data table?

hapham

Community Trekker

Joined:

Aug 11, 2016

Hi,

I'm analysing a data set that was sent to me looking similar to below table. There are 2 key things I want to obtain (and more after I could play with it):

  1. which item is critical (highest cost) for each year? This is something I could generate for each year separately on a column graph (better suggestions?)
  2. The trend for each iteam over the years. Now since the years are column names, I have troubles generating a graph for this. I don't want to manually update the data table to have years where Items' names are now. Is there an easy way for this? Of course, the data table I have is way bigger and more complex than this.

In addition, I will appreciate any suggestions for studying this type of data. I think there must be a way that maybe I can identify if something has a predictable trend and generate an equation for prediction as well.

 

 201620152014
Item 1$$$
Item 2$$$
Item 3$$$
1 REPLY
txnelson

Super User

Joined:

Jun 22, 2012

I suggest that you simply stack the 3 columns using

    Tables==>Stack

This will give you the basic table you will need to generate the graphs and analyses you are looking for.

Jim