Move many columns of data into three columns

[jwrightsd]

Hello, I have received data for 24 periods with over 50 columns of data. I want to move the data under three columns so I have repeating 24 months in one column, Fruit Type for each of the 24 months in another column and then the amount in the final column (see attachment). Rather than copy and paste these one by one, I was wondering if there was some formula I could use to do this for me. Thanks so much!!!

 

[alansidman]

Use Power Query to Unpivot your data.

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[jwrightsd]

Use Power Query to Unpivot your data.

Thank you. This video is showing exactly what I need to do. I have never used power query nor sure how I can get power query. I am using Excel 365. Do you know how I can get power query to try this?

 

[Fluff]

I am using Excel 365

Please see post#3

Do you know how I can get power query to try this

You already have it, it's called get & transform & is on the Data tab

 

[alansidman]

Since you are using O365, Power Query is part of native Excel. In your version, it is referred to as Get and Transform Data.

Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "Get & Transform Data").

It is a powerful yet simple way of getting, changing and using data from a broad variety of sources, creating steps which may be easily repeated and refreshed. I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.

- Follow this link to learn how to install Power Query in Excel 2010 / 2013.

- Follow this link for an introduction to Power Query functionality.

- Follow this link for a video which demonstrates how to use Power Query code provided.

 

[jwrightsd]

Please see post#3


You already have it, it's called get & transform & is on the Data tab

Thanks so much!!!

 

[Peter_SSs]

@jwrightsd
Two things:

1. When using "Mark as solution" please mark the post that actually contains the solution to help future readers. You had marked post #7 which clearly isn't the solution so I have moved the mark to post #2
   
   
2. You have been asked twice already in this thread, but could you please add your Excel version in your account details?
   If you ask further questions in the future it will assist helpers to provide a solution best suited to your particular version & may save them wasting time suggesting something that is not appropriate for you.