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.

Sample Data.xlsx

Help

Accepted answers

Nate1

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.

Sample_data_load.yxmd

All comments

ponraj

possible to share sample result you are looking for?

Nate1

Hi @alibink,

Sample_data_load.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703