Aggregate data from multiple sheets into a single sheet

Follow

Anson Chan

• September 08, 2020 01:40

I have 41 sets of workbook which I'd like to aggregate them into a single worksheet under a workbook. I am unable to locate such a function to do so in datameer.

Anyone can help me please?

0

• 

  Konsta Danyliuk

  • September 15, 2020 07:51

  Hello Anson.
  I hope you are doing fine and staying safe these days.

  One could bring data from several Sheets to the one using either Join or Union operations. Steps to follow would be:

  • Determine datasets you want to aggregate.
  • Add them to a Workbook (a new or an existing one).
  • Set up a Join or Union operations to bring data to a single Sheet.

  If you will share more background on your use-case, I'll try to provide more specific instructions. 

  1

  Comment actions Permalink

Please sign in to leave a comment.