How to append sheets/consolidate multiple sheets in one sheet

Maz Uddin

Hi All,

here are two different sheets populated from two different forms which are site specific

The forms have information for people to read which are site specific hence why two forms

Is there a way to append these two sheets into one like you can do on power bi using the append query function?

please can you advise

Maz Uddin

@Paul Newcome Hi Paul hope you are well

can you advise please on the above

Maz Uddin

@Genevieve P. Hi, hope you are well

can you advise on the above please?

Paul Newcome

Have you looked into creating a row report?

Maz Uddin

@Paul Newcome

I'm aware about the report function, but i wanted to append the sheets and run a helper column to do create a RAG.

Currently, I have 10+ sheets which I need to create a Rag for and I was hoping to avoid that as it is time consuming.

Genevieve P.

Hi @Maz Uddin

I agree with Paul - I would suggest creating an RAG column for each individual sheet. As long as the sheets are set up the same, you can write the formula once then copy/paste this same formula into all of your sheets.

Then you can combine two or three or however many into one Report to give you a different view.

An alternative would be to re-structure your set-up to have multiple forms feeding into one large master sheet, then use multiple reports to break out rows into different groupings.

Cheers,

Genevieve