Split data from data model into separate sheets based on a clolumn value

kkalomiris

New member
Joined
Dec 22, 2016
Messages
5
Reaction score
0
Points
0
Excel Version(s)
365
Hello,
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
 
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.
 
Back
Top