Create a macro to take data from one row and transpose it to columns for use with Integrations in SmartConnect.
The originating data is shown below
Using VB in excel we have created code to copy, paste & transpose the data. Sample code is below
The way that we have designed the macro keeps the original data and pastes the information on to a new sheet. The macro has also been designed to place protection on the excel workbooks preventing any formulas being amended accidently and runs at a good pace.
With the data being in the new format it will enable us to integrate in to GP using SmartConnect and save us from having to manually re-type large amounts of data.