Hi, I have this excel file. [image] There are 6 stores in this file, and I need to split data by each store and save in 6 different excel files. For example, File 1 should be Header + Whole rows for Store A + SUM File 2 should be Header + Whole rows for Store B + SUM File 3 should be Header …

How to split data and save in excel files

lakshman (Ganta lakshman) October 10, 2019, 2:00am 12

Check below thread and follow the steps to resolve this issue.

Topic		Replies	Views
Spliting excel data Help	12	1084	August 31, 2019
How to use Excel to start and write-back(Filter & Datatable Problems) Studio datatable , excel , studio , question , activities_panel , filter	8	1915	November 3, 2021
Splitting an excel file into multiple excel files Activities excel , question	5	1461	April 7, 2023
Read and split datatable Studio	23	93	April 10, 2025
Split Table Activities excel , activities , question	9	847	March 18, 2023