Separate excel files per facility

I have an excel database that I brought in, I have sorted out the information I need and have it all in order. I have around 96 different providers in the file and each provider has around 2 thousand lines lines of data I need, I would like to output each one of the providers into a separate file or one excel file with a tab for each providers.

Output

Accepted answers

All comments

https://community.alteryx.com/t5/Interactive-Lessons/Writing-Data/ta-p/74561

@jlfromm sample attached

Providers_21052024.yxzp

Screenshot 2024-05-21 102445.png When I do that I am getting and error Target Excel file maybe corrupted. Cannot find required file or element

One of your tab names may have an unsupported excel tab character - or may be blank/null.

@jlfromm Change the output options to Overwirte Sheet or Range

@binu_acs I changed it to Overwrite Sheet or range and still the same error

@jlfromm Make sure you dont have any blank/Null values in the billing providers name

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703