Use Extract Data for Microsoft Excel to extract selected rows and convert them to columns. Get Excel for Mac add-ons by Ablebits to cope with daily tasks easily. Apps for Excel for Mac Add-ins by Ablebits are designed to help you with everyday worksheet tasks in Excel 2016 for Mac, desktop version of Office 365 for Mac, and Excel 2011.
This question already has an answer here:. 2 answers I am trying to merge 2 worksheets where only one col matches in content. Column'A' in both worksheets have matching values but all other fields are different. Worksheet1: Col'A' colb colc cold (worksheet1 has 25,000 rows) Worksheet2: Col'A' cole colf colg (worksheet2 has 22,000 rows - so some rows are missing) NEW COMBINED WORKSHEET NEEDS TO LOOK LIKE THIS: Col'A' colb colc cold cole colf colg (new worksheet has 25,000 rows) How can I do this? Example illustration here.