Is it possible to combine/merge two sheets into one? So that I can see all the entries from multiple sheets in one place? They need to remain separate as they are for two different years.
The main reason is to simplify the process of displaying our inventory on our website.
Thank you!
Hi,
Currently, there is no standard feature to merge separate sheets.
Let’s say you have sheets for 2020 and 2021. You’ll need to follow the steps below.
Step 1. Export entries from the “2021” sheet.
Step 2. Import the entries to the “2020” sheet.
Step 3. Delete the current “2021” sheet. Then, create a multiple version based on the “2020” sheet to have a new “2021” sheet.
Step 4. Create multiple version based on the “2020” sheet to have a new “2020&2021” sheet.
Step 5. Apply a fixed filter on the “2020” and “2021” sheets so that they only display the entries within the year.
Step 6. Embed the “2020&2021” sheet which contains all entries.
Thank you for the info!