I'm sure this is easy. I can do this all day in Access, but my boss wants this done in Excel for some reason.
I have 2 columns of information. The first column is the identifier, and the second column is a list a data points, both are pulled from an SQL-ODBCR, and I can not import it any other way. Example;
SEE Sheet 1
Example.xls
In the full version it ends up being 250 different agencies, each with about 50 data points, and 30 data types each. I need to compile this data to each Agency in a seperate column with the data points below it. I have to do this for about 30 different reports. So doing it manually will take weeks. I need it to look like this, Example;
SEE Sheet 2
Example.xls
And so on and so forth.
Any help would be greatly appreciated, I am completely lost. If you need more information, I can clarify.
Thanks in advance.
Bookmarks