View Full Version : Split data from data model into separate sheets based on a clolumn value

2019-02-25, 12:23 PM
does anyone knows has to split data from an excel data model into separate sheets based on a column value?
I have found many solution, mainly based on VBA, but all have as a input a sheet and not data model's data.
Please keep in mind also, that my data are more than 6 mil rows, so I cannot upload them into a sheet, due to limitation of 1.4 mil rows

Thanks a lot

2019-02-25, 04:13 PM
Upload a sample of your data with a before and after scenario mocked up so that we can supply you with a workable solution. Without seeing your data, there is no way of knowing how you want your data split.