Load dynamically Month column

[#1]

Hi,

I need help to implement this feature in my script:

I have an excel file with the last 6 month

Jan 16	Feb 16	Mar 16	Apr 16	May 16	Jun 16
value	value	value	value	value	value
value	value	value	value	value	value

how con I upload this automatically in my sheet without modify the structure of the table?

My idea was to have a pivot table with all month for 5 years and display only them specified into the excel file, but if I try this idea i receive an upload error.

Anyone has some idea on how to resolve my problem?

Other ideas are accepted of course.

Thanks

[sunny_talwar · Accepted solution]

May be use a crosstable load here:

The Crosstable Load

[MarcoWedel]

Please post a small sample of your excel file, the script and the error message.

thanks

regards

Marco