Hello Guys
we get a significant number of excel sheet and we need to push them to the DB schema attached is a sample data and also the output we want any one have an idea
Thanks
Question
Excel
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+66
What you want is transpose. Study this excellent article. Only additional thing you need to do is rename the empty rows / columns to city & year but that could be automated as well. Aggregator, validate vales, in integer then year, else city.