Extracting data from Multiple columns to a Single row

[Andy McGooner]

Hi All,

I have a spread sheet that contains many columns of data which is split into 4 data types per month (Note extract below only shows 3 and the first 3 months);

Feb-14 Mar-14 Apr-14
PM0 PM4 PM6 PM0 PM4 PM6 PM0 PM4 PM6
Total 1 291 716 1 298 722 1 291 721
Total 1 1 262 644 2 265 655 2 262 648

Now i an trying to extract each of the data inputs into one row show as youcan see below;

Feb-14 Mar-14 Apr-14
PM0 - Total 1 1 2 2
PM4 - Total 1 262 265 262
PM6 - Total 1 644 655 648

Now I can do this manually by referencing each cell but as I said there aremultiple columns and worksheets associated with this. I also thought I could maybe do a Vlookup and then maybe drag it across the cells. however it needs to be able to count every 4th row or again its along tedious route to change the formula. Therefore is there a means of doing this or maybe an alternative method which may do this easier.

Anyway any help would be greatly appreciated.

Thanks in advance,

Andy
Excel 2010

 

[Andy McGooner]

Hi Ron,

Much appreciated that worked a treat, will stick this in my useful code file for future reference. You are a star as this was doing my head in. Anywayagain thanks for your help it was greatly appreciated, hopefully i can return the favour sometime in the future.

Andy