Search results

I have a workbook that contains multiple sheets that tracks financials of partners. I want to be able to allocate columns based on number of partners and sum/ calculate based on the number of partners. See the attached sheet - it has 6 partners and columns for 6 partners and summation of...

Thanks everyone. I was able to use PowerQuery and do it.

I have a spreadsheet that lists entity and its users Entity Name Users XYZ Entity abc; def; ghi; ... I want to convert this to Entity User XYZ Entity abc XYZ Entity def XYZ Entity...

I do have excel 2016. I posted a sample file with data in the Jun sheet. You could use multiple copies of the same as sample timesheets for each person.

Here is the file. This file is provided to each member of the team. I want to have a consolidated version that shows in the summary sheet the totals by month and in the individual sheets the totals by day. Thank you for your help

I have a template - a timesheet template with projects as rows and dates as columns and a sheet in the workbook for each month. Each developer fills a timesheet and sends it. Timesheet_D1, Timesheet_D2, Timesheet_D3 I want to build a consolidated timesheet that consolidates the values for each...