Need help to convert data as in Sheet 1 to how it is in Sheet 2. Any help will be greatly appreciated.
Need help to convert data as in Sheet 1 to how it is in Sheet 2. Any help will be greatly appreciated.
Welcome to the Board.
A nice quick cheat is to use a Pivot Table with Multi Consolidation Range - once set-up you can drill into Grand Total to get the source data transposed... see example attached.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
This Works! Thnx a ton . saved me a ton of time.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks