Help Needed Reading an Excel File (Sample Attached)

[alibink]

Hi guys,

Looking for some help /guidance in reading the attached sample file.

1. Products in Field A can grow in rows

2. Sub Group in Field B can grow in rows

3. Year and Months will grow in columns

Aiming to load data in database table and can't do that because the years and months are in cross tab.

[ponraj]

possible to share sample result you are looking for?

[Nate1 · Accepted solution]

Hi @alibink,

I took a shot at one way to load the data. It used some transpose tools to load the which will dynamic add new columns in the future months. It does change the structure of the data some so it might not work for you ultimate goal. Feel free to let us know more specifically what you need. 

[alibink]

Dear Nate,

Thanks and much appreciated. With the solution provided I got the idea and the headstart and with minor tuning I will get to the desired output.