Excel “Macro” Project.
I need a “macro” or subroutine, or whatever they are called these days, to automatically transpose spreadsheet BEFORE to spreadsheet AFTER, both attached. (FreelancerSampleBEFORE to FreelancerSampleAFTER).
Hopefully, the macro will automatically select the number of records with the same column A, (e.g. select 2 columns for Adamstown, and 4 for Albion Park), and then do a “PasteSpecial/Transpose before going down to the next column A entry. Obviously, where there is only 1 record for a particular column A entry, then selection and transpose is unnecessary, such as with Aarons Pass and Abbotsford.
Each “real” spreadsheet contains up to 5,000 records, which is why I need the macro.
5 freelanceria on tarjonnut keskimäärin 32 $ tähän työhön
Hello! *SEEK NO MORE!* This is 'a piece of cake' for me! I'll do it VERY FAST and ACCURATELY! Let me help! Highly experienced in Excel macros (high-school IT professor and programer! THANKS!