Split Data into Excel Sheets based on Category Column

[Blessy Clara]

Hi All

I have a excel sheet of 80,000 + records
There is a column named Category- Which contains a a number code
Each category has multiple records

Requirement - I want to separate the data into different excel files based on these category code
example

Category	Col B	Col C	Col D	Col E	Col F	Col AZ
0191 <tbody> </tbody>	Data	Data	Data	Data	Data	Data
0191	Data	Data	Data	Data	Data	Data
0191	Data	Data	Data	Data	Data	Data
0191	Data	Data	Data	Data		Data
0191	Data	Data	Data	Data	Data	Data
8511 <tbody> </tbody>		Data	Data	Data	Data
8511 <tbody> </tbody>	Data	Data	Data	Data	Data	Data
8511 <tbody> </tbody>
8511 <tbody> </tbody>

<tbody>
</tbody>

So all Records having category 0191 to be in one excel file
Next all records with category 8511 should be in new excel file
like wise data to be separated to different Excel files based on category

First Row is header running from A to AZ Columns
Column 1 contains the category
Thanks in Advance

There are more categories - So manual work is too tedious - Any help would be very useful

 

[jim may]

Is there any significance to the Category #'s with the Borders? Strange how 0191 is set out and how 8511 seems to break the pattern. Also, like in 8511 0 Can it have Blank Data in Columns B thru AZ our whatever it is? Just wondering...

 

[Blessy Clara]

Is there any significance to the Category #'s with the Borders? - Nope these are just numbers - No borders - I think Borders must have come when i copied the number from excel
8511 Can it have Blank Data in Columns B thru AZ our whatever it is? Just wondering... - It does have few blank columns/cells but not complete blank rows

Hope I have answered - Thanks for your response