How to normalise (unpivot) 13 columns from 16 in vba?

**gerotutu** · 08-13-2015, 08:55 PM

Hi experts!

I have this table and I would like to replace JAN, FEB, MAR... for only one column called MONTH with a macro

How to normalise (unpivot) 16 columns.png

You can see also a TOTAL column (which is the total value for the whole year that's not always a sum of months) that I am thinking that it would be better to include in the MONTH column in order to not have those values for each month row once is normalised, what do you suggest?

I have seen some macros in the internet but they are exceding by far my VBA's knowledge and skills and I can't make them work. I tried for example this one http://dailydoseofexcel.com/archives...ivot-shootout/ but I had no success.

Many thanks for your help in advance

**Pepe Le Mokko** · 08-14-2015, 03:22 AM

Don't know if this still works http://www.tek-tips.com/faqs.cfm?fid=5287

You could eventually record the macro?

**gerotutu** · 08-14-2015, 11:06 AM

Unfortunately It doesn't help me. I knew that procedure but is manual (and I need it in a macro) and it only works for this kind of structure with only one descriptive column (like "Acct"):

Acct Jan Feb Mar
Acct01 234 123 567
Acct02 345 234 678
Acct03 456 345 789

Mine has more than one of those descriptive fields: Indicator, Year, Total and Channel

The ideal output would be a table like:
Channel | Indicator | Year | Month (including total)

Thanks for you help

**gerotutu** · 08-15-2015, 04:52 PM

any help on this?

How to normalise (unpivot) 13 columns from 16 in vba?

LinkBack

Thread Tools

Rate This Thread

Display

How to normalise (unpivot) 13 columns from 16 in vba?

Re: How to normalise (unpivot) 13 columns from 16 in vba?

Re: How to normalise (unpivot) 13 columns from 16 in vba?

Re: How to normalise (unpivot) 13 columns from 16 in vba?

Thread Information

Users Browsing this Thread

Similar Threads

Unpivot Data

Unpivot and stack data

how to unpivot

Unpivot Data

Normalise a pivot table - this is an easy one for you guys.

normalise data across duplicates but keep field containing overwritten values-possible?

Need 'unpivot' help for attached spreadsheet data.

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions