Forum Discussion

Nidhi Soni's avatar
Nidhi Soni
Copper Contributor
Jun 23, 2017

How to merge multi sheets into master but keeping the date format?

I'm newbie !

Work as a Salesforce admin. I know basic excel.

what I need to know that how can I merge multi sheets into one but wants to keep the date format as well.

For e.g 1st spreadtsheet (Jan 1- Jan 15)

2nd spreadsheet (Jan 16- Jan 31) and so on.

another thing all spreadsheet doesn't have same fields and some fields are blank as well

Is there any possible way to do it ?

Thanks in advance !

excel

3 Replies

  • Oliver F.'s avatar
    Oliver F.
    Copper Contributor
    Jun 24, 2017

    As Wyn described, it is hard to give you a very easy solution.

     

    There are 2 main solutions I would suggest:

    - either create a date table (e.g. start with 01.01.2017, in each following row add +1) and add all values behind each date, using the vlookup or sumif function

    - or https://youtu.be/VeS0fh8xUVA and https://youtu.be/ldoQws7Zbx8

     

    Best, Oliver

  • Wyn Hopkins's avatar
    Wyn Hopkins
    MVP
    Jun 24, 2017
    Hi Nidhi,

    No simple answer unfortunately.

    First aim would be to fix the process to avoid having different data in different sheets / files. Fixing the process and structuring the data correctly in the first place can save masses of re-work and headaches.

    Next best solution would be to learn a bit about Power Query (called Get & Transform) in Excel 2016. It's great at consolidating data from different sheets / files etc.

Resources