Is there a way to export to excel and have each unique value in column1 be put in] its own worksheet?

Example:
1,data
1,data
1,data
2,data
2,data

Would export to excel with 2 sheets, one sheet has 1 with all data, and the other has 2 with all data.

This message has been edited. Last edited by: FP Mod Chuck,

Hi BSBAL18

You can use Table of Contents (You will find it on the Format tab) with Excel and it will create a separate worksheet for each value of the table of contents field.

Here is a sample


TABLE FILE CAR
SUM
CAR.BODY.DEALER_COST
CAR.BODY.RETAIL_COST
CAR.BODY.SALES
BY CAR.ORIGIN.COUNTRY
BY CAR.COMP.CAR
BY CAR.CARREC.MODEL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT XLSX
ON TABLE SET XLSXPAGESETS ON
ON TABLE SET COMPOUND 'BYTOC 1'
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END


This message has been edited. Last edited by: FP Mod Chuck,

Timeless information:

quote:

ON TABLE PCHOLD FORMAT XLSX
ON TABLE SET XLSXPAGESETS ON
ON TABLE SET COMPOUND 'BYTOC 1'

Just in case anyone needs it.

@Fp Mod Chuck :