--- title: How to record the FSMA 204 Transformation CTE in a sortable spreadsheet description: This article demonstrates a best-practice method of recording the FSMA 204 Transformation Critical Tracking Event in a sortable spreadsheet for the FDA image: https://trackvision.ai/hubfs/FSMA%20Spreadsheet%20Featured%20Image%202-1.png --- [![Group 4638](https://trackvision.ai/hs-fs/hubfs/Group%204638.png?width=150&height=20&name=Group%204638.png "Group 4638")](https://www.trackvision.ai) [![Logo-Long-Blue-On-Invis2-1](https://trackvision.ai/hs-fs/hubfs/Logo-Long-Blue-On-Invis2-1.png?width=150&height=20&name=Logo-Long-Blue-On-Invis2-1.png "Logo-Long-Blue-On-Invis2-1")](https://www.trackvision.ai) [Platform](https://trackvision.ai/platform) [![Vector-2](https://trackvision.ai/hubfs/Vector-2.svg) ![Vector-1](https://trackvision.ai/hubfs/Vector-1.svg) Platform Overview](https://trackvision.ai/platform) [![gs1 epcis2](https://trackvision.ai/hubfs/gs1%20epcis2.svg) ![gs1 ecpis](https://trackvision.ai/hubfs/gs1%20ecpis.svg) GS1 EPCIS 2.0 Repository & API](https://trackvision.ai/capabilities/epcis-repository) [![gs1 digital link](https://trackvision.ai/hubfs/gs1%20digital%20link.svg) ![gs1 digital](https://trackvision.ai/hubfs/gs1%20digital.svg) GS1 Digital Link Resolver](https://trackvision.ai/capabilities/gs1-digital-link-resolver) [![digital identity](https://trackvision.ai/hubfs/digital%20identity.svg) ![digital identities](https://trackvision.ai/hubfs/digital%20identities.svg) Digital Identities & Serialization](https://trackvision.ai/capabilities/digital-identities-and-serialization) [![traceability](https://trackvision.ai/hubfs/traceability.svg) ![product traceability](https://trackvision.ai/hubfs/product%20traceability.svg) Product Traceability](https://trackvision.ai/capabilities/product-traceability) [![ai](https://trackvision.ai/hubfs/ai.svg) ![ai for supply](https://trackvision.ai/hubfs/ai%20for%20supply.svg) AI for Supply Chain](https://trackvision.ai/capabilities/ai-for-supply-chain) [![no code](https://trackvision.ai/hubfs/no%20code.svg) ![nocode config](https://trackvision.ai/hubfs/nocode%20config.svg) No-Code Configuration](https://trackvision.ai/capabilities/no-code-configuration) [![worflow](https://trackvision.ai/hubfs/worflow.svg) ![workflow](https://trackvision.ai/hubfs/workflow.svg) Workflow Engine](https://trackvision.ai/capabilities/workflow-engine) [![sensor data](https://trackvision.ai/hubfs/sensor%20data.svg) ![sensor data-1](https://trackvision.ai/hubfs/sensor%20data-1.svg) Sensor Data Management](https://trackvision.ai/capabilities/sensor-data) [![certification managment](https://trackvision.ai/hubfs/certification%20managment.svg) ![cert management](https://trackvision.ai/hubfs/cert%20management.svg) Certification Management](https://trackvision.ai/capabilities/certification-management) Solutions ![Frame-1](https://trackvision.ai/hubfs/theme/Frame-1.svg) ![regulatory comp-1](https://trackvision.ai/hubfs/regulatory%20comp-1.svg) Regulatory Compliance [![provenance assurance](https://trackvision.ai/hubfs/provenance%20assurance.svg) ![provenance assur](https://trackvision.ai/hubfs/provenance%20assur.svg) Provenance Assurance](https://trackvision.ai/solutions/provenance) [![recall monitor-1](https://trackvision.ai/hubfs/recall%20monitor-1.svg) ![recall monitoring-1](https://trackvision.ai/hubfs/recall%20monitoring-1.svg) Recall Monitoring](https://trackvision.ai/solutions/recall-monitoring) [![recall exec-2](https://trackvision.ai/hubfs/recall%20exec-2.svg) ![recall exec-3](https://trackvision.ai/hubfs/recall%20exec-3.svg) Recall Execution](https://trackvision.ai/solutions/recall-execution) [![diversion detect](https://trackvision.ai/hubfs/diversion%20detect.svg) ![diversion detect-1](https://trackvision.ai/hubfs/diversion%20detect-1.svg) Diversion Detection](https://trackvision.ai/solutions/product-diversion) [![waste](https://trackvision.ai/hubfs/waste.svg) ![waste reduct](https://trackvision.ai/hubfs/waste%20reduct.svg) Waste Reduction](https://trackvision.ai/solutions/waste-reduction) [![certification monitoring](https://trackvision.ai/hubfs/certification%20monitoring.svg) ![certification monit](https://trackvision.ai/hubfs/certification%20monit.svg) Certification Monitoring](https://trackvision.ai/solutions/certification-monitoring) [![cold chain](https://trackvision.ai/hubfs/cold%20chain.svg) ![cold chaing monit](https://trackvision.ai/hubfs/cold%20chaing%20monit.svg) Cold Chain Monitoring](https://trackvision.ai/solutions/cold-chain-monitoring) [![carbon](https://trackvision.ai/hubfs/carbon.svg) ![carbon footprint red](https://trackvision.ai/hubfs/carbon%20footprint%20red.svg) Carbon Footprint Reduction](https://trackvision.ai/solutions/carbon-footprint-reduction) [![fresh food](https://trackvision.ai/hubfs/fresh%20food.svg) ![fresh\_food](https://trackvision.ai/hubfs/fresh_food.svg) FSMA Section 204 Compliance](https://trackvision.ai/solutions/fsma-204) [![pharmacy](https://trackvision.ai/hubfs/pharmacy.svg) ![pharmacy-1](https://trackvision.ai/hubfs/pharmacy-1.svg) DSCSA Compliance](https://trackvision.ai/solutions/dscsa) [![recall dpp](https://trackvision.ai/hubfs/recall%20dpp.svg) ![recall dpp-1](https://trackvision.ai/hubfs/recall%20dpp-1.svg) Digital Product Passports](https://trackvision.ai/solutions/dpp) Industries [![fresh food](https://trackvision.ai/hubfs/fresh%20food.svg) ![fresh\_food](https://trackvision.ai/hubfs/fresh_food.svg) Fresh Food](https://trackvision.ai/industries/fresh-food) [![apparel](https://trackvision.ai/hubfs/apparel.svg) ![apparel-1](https://trackvision.ai/hubfs/apparel-1.svg) Apparel](https://trackvision.ai/industries/apparel) [![wine](https://trackvision.ai/hubfs/wine.svg) ![wine-1](https://trackvision.ai/hubfs/wine-1.svg) Wine & Spirits](https://trackvision.ai/industries/wine-and-spirits) [![grocery](https://trackvision.ai/hubfs/grocery.svg) ![grocery-1](https://trackvision.ai/hubfs/grocery-1.svg) Grocery](https://trackvision.ai/industries/grocery) [![restaurant](https://trackvision.ai/hubfs/restaurant.svg) ![restaurants](https://trackvision.ai/hubfs/restaurants.svg) Restaurants](https://trackvision.ai/industries/grocery) [![pharmacy](https://trackvision.ai/hubfs/pharmacy.svg) ![pharmacy-1](https://trackvision.ai/hubfs/pharmacy-1.svg) Pharmaceutical](https://trackvision.ai/industries/pharma) [Resources](https://trackvision.ai/resources) [![blog](https://trackvision.ai/hubfs/blog.svg) ![blog-1](https://trackvision.ai/hubfs/blog-1.svg) Blog](https://trackvision.ai/blog) [![Digital Link Icon](https://trackvision.ai/hubfs/qr-2.svg) ![qr-3](https://trackvision.ai/hubfs/qr-3.svg) What is GS1 Digital Link?](https://trackvision.ai/blog/what-is-gs1-digital-link) [![EPCIS Icon](https://trackvision.ai/hubfs/database-4.svg) ![database](https://trackvision.ai/hubfs/database.svg) What is GS1 EPCIS?](https://trackvision.ai/blog/what-is-gs1-epcis-2.0) [![diversion detect](https://trackvision.ai/hubfs/diversion%20detect.svg) ![diversion detect-1](https://trackvision.ai/hubfs/diversion%20detect-1.svg) Technical Documentation](https://docs.trackvision.ai/) [About us](https://trackvision.ai/about) [![recall dpp](https://trackvision.ai/hs-fs/hubfs/recall%20dpp.webp?width=35&height=28&name=recall%20dpp.webp) ![recall dpp-1](https://trackvision.ai/hubfs/recall%20dpp-1.svg) Our Team](https://trackvision.ai/about) [![share-2](https://trackvision.ai/hubfs/share-2.svg) ![share data](https://trackvision.ai/hubfs/share%20data.svg) Our Partners](https://trackvision.ai/partners) [Contact us](https://cta-eu1.hubspot.com/web-interactives/public/v1/track/click?encryptedPayload=AVxigLK%2FT2tXtCwLkNybssrDRz0W%2Fq8th3A7d917FyuSpeU0UfIL1XhhHv4zTr%2Bm%2BsTp3KoQ9jgV70Xu1z%2FF8iESdFL0l9dWkTO4WxGxrVxlJKEcEtUrWc3X2HcFmH6WCmv87%2BxNm4MaaeIdXsupa4qybdsJZYCRxo5NGGSwDJ3C644Y%2BA%3D%3D&portalId=143236257) [![Group 4638](https://trackvision.ai/hs-fs/hubfs/Group%204638.png?width=150&height=20&name=Group%204638.png "Group 4638")](https://www.trackvision.ai) [Platform](https://trackvision.ai/platform) Solutions Industries [Resources](https://trackvision.ai/resources) [About us](https://trackvision.ai/about) [Contact us](https://cta-eu1.hubspot.com/web-interactives/public/v1/track/click?encryptedPayload=AVxigLK%2FT2tXtCwLkNybssrDRz0W%2Fq8th3A7d917FyuSpeU0UfIL1XhhHv4zTr%2Bm%2BsTp3KoQ9jgV70Xu1z%2FF8iESdFL0l9dWkTO4WxGxrVxlJKEcEtUrWc3X2HcFmH6WCmv87%2BxNm4MaaeIdXsupa4qybdsJZYCRxo5NGGSwDJ3C644Y%2BA%3D%3D&portalId=143236257) back [Platform](https://trackvision.ai/platform) [![Vector-2](https://trackvision.ai/hubfs/Vector-2.svg) Platform Overview](https://trackvision.ai/platform) [![gs1 epcis2](https://trackvision.ai/hubfs/gs1%20epcis2.svg) GS1 EPCIS 2.0 Repository & API](https://trackvision.ai/capabilities/epcis-repository) [![gs1 digital link](https://trackvision.ai/hubfs/gs1%20digital%20link.svg) GS1 Digital Link Resolver](https://trackvision.ai/capabilities/gs1-digital-link-resolver) [![digital identity](https://trackvision.ai/hubfs/digital%20identity.svg) Digital Identities & Serialization](https://trackvision.ai/capabilities/digital-identities-and-serialization) [![traceability](https://trackvision.ai/hubfs/traceability.svg) Product Traceability](https://trackvision.ai/capabilities/product-traceability) [![ai](https://trackvision.ai/hubfs/ai.svg) AI for Supply Chain](https://trackvision.ai/capabilities/ai-for-supply-chain) [![no code](https://trackvision.ai/hubfs/no%20code.svg) No-Code Configuration](https://trackvision.ai/capabilities/no-code-configuration) [![worflow](https://trackvision.ai/hubfs/worflow.svg) Workflow Engine](https://trackvision.ai/capabilities/workflow-engine) [![sensor data](https://trackvision.ai/hubfs/sensor%20data.svg) Sensor Data Management](https://trackvision.ai/capabilities/sensor-data) [![certification managment](https://trackvision.ai/hubfs/certification%20managment.svg) Certification Management](https://trackvision.ai/capabilities/certification-management) back Solutions ![Frame-1](https://trackvision.ai/hubfs/theme/Frame-1.svg) Regulatory Compliance [![provenance assurance](https://trackvision.ai/hubfs/provenance%20assurance.svg) Provenance Assurance](https://trackvision.ai/solutions/provenance) [![recall monitor-1](https://trackvision.ai/hubfs/recall%20monitor-1.svg) Recall Monitoring](https://trackvision.ai/solutions/recall-monitoring) [![recall exec-2](https://trackvision.ai/hubfs/recall%20exec-2.svg) Recall Execution](https://trackvision.ai/solutions/recall-execution) [![diversion detect](https://trackvision.ai/hubfs/diversion%20detect.svg) Diversion Detection](https://trackvision.ai/solutions/product-diversion) [![waste](https://trackvision.ai/hubfs/waste.svg) Waste Reduction](https://trackvision.ai/solutions/waste-reduction) [![certification monitoring](https://trackvision.ai/hubfs/certification%20monitoring.svg) Certification Monitoring](https://trackvision.ai/solutions/certification-monitoring) [![cold chain](https://trackvision.ai/hubfs/cold%20chain.svg) Cold Chain Monitoring](https://trackvision.ai/solutions/cold-chain-monitoring) [![carbon](https://trackvision.ai/hubfs/carbon.svg) Carbon Footprint Reduction](https://trackvision.ai/solutions/carbon-footprint-reduction) back Industries [![fresh food](https://trackvision.ai/hubfs/fresh%20food.svg) Fresh Food](https://trackvision.ai/industries/fresh-food) [![apparel](https://trackvision.ai/hubfs/apparel.svg) Apparel](https://trackvision.ai/industries/apparel) [![wine](https://trackvision.ai/hubfs/wine.svg) Wine & Spirits](https://trackvision.ai/industries/wine-and-spirits) [![grocery](https://trackvision.ai/hubfs/grocery.svg) Grocery](https://trackvision.ai/industries/grocery) [![restaurant](https://trackvision.ai/hubfs/restaurant.svg) Restaurants](https://trackvision.ai/industries/grocery) [![pharmacy](https://trackvision.ai/hubfs/pharmacy.svg) Pharmaceutical](https://trackvision.ai/industries/pharma) back [Resources](https://trackvision.ai/resources) [![blog](https://trackvision.ai/hubfs/blog.svg) Blog](https://trackvision.ai/blog) [![Digital Link Icon](https://trackvision.ai/hubfs/qr-2.svg) What is GS1 Digital Link?](https://trackvision.ai/blog/what-is-gs1-digital-link) [![EPCIS Icon](https://trackvision.ai/hubfs/database-4.svg) What is GS1 EPCIS?](https://trackvision.ai/blog/what-is-gs1-epcis-2.0) [![diversion detect](https://trackvision.ai/hubfs/diversion%20detect.svg) Technical Documentation](https://docs.trackvision.ai/) back [About us](https://trackvision.ai/about) [![recall dpp](https://trackvision.ai/hs-fs/hubfs/recall%20dpp.webp?width=35&height=28&name=recall%20dpp.webp) Our Team](https://trackvision.ai/about) [![share-2](https://trackvision.ai/hubfs/share-2.svg) Our Partners](https://trackvision.ai/partners) back Regulatory Compliance [![fresh food](https://trackvision.ai/hubfs/fresh%20food.svg) FSMA Section 204 Compliance](https://trackvision.ai/solutions/fsma-204) [![pharmacy](https://trackvision.ai/hubfs/pharmacy.svg) DSCSA Compliance](https://trackvision.ai/solutions/dscsa) [![recall dpp](https://trackvision.ai/hubfs/recall%20dpp.svg) Digital Product Passports](https://trackvision.ai/solutions/dpp) [epcis](https://trackvision.ai/blog/tag/epcis) [fsma204](https://trackvision.ai/blog/tag/fsma204) [fda](https://trackvision.ai/blog/tag/fda) Published: 28 August 2024 | [Jonathan Ling](https://trackvision.ai/blog/author/jonathan-ling) # How to record the FSMA 204 Transformation CTE in a sortable spreadsheet The “Transformation” event is one of the seven traceability Critical Tracking Event (CTE) types American businesses will be required to record under Section 204 of the Food Safety Modernization Act (FSMA). Here are the relevant record keeping requirements specified by the FDA: ![](https://lh7-rt.googleusercontent.com/docsz/AD_4nXcg5gGZbJJ41U0L5rfvEYAZPimfWp0c3cYmpHEO-K8gPhPoJ5a-z4goz80669h___f4B5hnTELqP4EukzPkMnjGzaorNEbWxVuZBVfm5cWc2aQ1D5rChBlHPUtZpZbUgpUqRLd98EUs6-1aJ4WcqRPfFQxt?key=aoQS1ScS7KXCoFCH2o5hHg) The Transformation event is a little different from the other CTEs. A CTE like “Shipping” is simple to represent as a line on a spreadsheet because one event refers to one Traceability Lot Code. But a transformation event can refer to ***several*** traceability lot codes: during processing or manufacturing, multiple inputs are combined or processed to produce a new batch/lot of output food. Consider the example below: Acme Foodworks, a fictitious food processor, has produced a lot of 200 units of packed salads with the code “S101”. To do this, they have used 100 pounds of lettuce from lot “L101”, and 50 pounds of the same type of lettuce from a different lot (“L201”), and 40 pounds of tomato from lot “T801”. ![](https://lh7-rt.googleusercontent.com/docsz/AD_4nXd9YcbBIzRWbZS4ybV7DkE-WnUCyX8dsY2WResVGizHQYzRclMjF6dQktCj9U0g0H4qxIIdK7k7rKpJihN9fIR9RN0INeDTarvpfI-3AxOMOfmOmEIIV_CU7n5ZFZxgqDfaO9lGbPuPx7aZ0NKHJsfbfWkG?key=aoQS1ScS7KXCoFCH2o5hHg) Three different lots were processed (“Transformed”) to produce one lot of Packed Salads. What is a good way of representing this “many to one” relationship in a row-based spreadsheet?  Our objective is to ensure that we can sort and filter to quickly look for specific Transformation Events that contain specific Lot Codes. In our FSMA 204 Sortable Spreadsheet Example ([download it here](https://trackvision.ai/fsma-204-spreadsheet)), we recommend a method where the single traceability event is split over several rows: ![](https://lh7-rt.googleusercontent.com/docsz/AD_4nXc77ZjDrULcfdkrGo7-GRROu_8hauONT2A1zrQt04TojCL3avDmCndaBiwxQRAx4HK7kJE0FazNRnKRDth1c0HjjCpYSBt_xJ_1_24oWJVncfmiq6IdbzIwBpfDPBsrdJaeWB807Pyd4cAOfnvJCHPD8G0?key=aoQS1ScS7KXCoFCH2o5hHg) The “Event ID” field indicates that all three rows are part of the same logical Transformation event. Some KDEs, such as the Event Date/Time (*“Date transformation was completed”*) and Event Location (*“Location description for where you transformed the food”*) are repeated over the three rows.  Each row has a unique reference to an input traceability lot code and quantity - one row for each lot that was used to produce the output food:  ![](https://lh7-rt.googleusercontent.com/docsz/AD_4nXfuxsfKgVSojqTqzAgHvtDNlTKAGSbDGrxw6S0qNnAP0nWcN8u91aLEkBwSZOyvDPUXok-znMi5DQ59oBq1MdcRDhbE5lHedIoNQrhjhmq4tdHOjFkXRdtkiBMq2AWQEzYTzXjcA5NI-gWFIT5ioC5oP9YL?key=aoQS1ScS7KXCoFCH2o5hHg) The details of the output Lot that was produced (the packed salads) is kept in separate columns, with the values repeated, since each of the three unique inputs are related to the one output. ![](https://lh7-rt.googleusercontent.com/docsz/AD_4nXeYZgJeNDHYJRAvHtCB2iU-ifSuCaCcQmV3FWdow3qtDadkHJB0e2HJR7xpLTmhpEhbfrt-_5BJqATiDjAYzDZF8NyCTgw_rryZ8oGKsp0hUKB8-VQSAtRhTFZFW9wPiuehw5kcO2e1xARinX4ponnybPeD?key=aoQS1ScS7KXCoFCH2o5hHg) This technique is useful because it allows the FDA to quickly filter your spreadsheet to find specific Traceability Lot Codes that they are looking for.  For example, you could filter to find all the input ingredient Lots that were used to produce the output salad lot “S101”: ![](https://lh7-rt.googleusercontent.com/docsz/AD_4nXcllMftU7IsX90y23lrAEm1F1WdixYvwvNFrg5Knt2VGxHqCMqvv5oNTzS4AnzxVsKUYDJ8ShyifAMRWy8JxqK_XpVy3qcDj9jtf5K62cK6UM80_zjAzyp6MAkNU2jSv4KtWyYpsWfRTOhWP8dMPIvo8dt3?key=aoQS1ScS7KXCoFCH2o5hHg) Similarly, you could filter for the input ingredient lot “L501” to find all instances where this lot was used as an ingredient in a manufacturing process: ![](https://lh7-rt.googleusercontent.com/docsz/AD_4nXeEncwx1rK7QUuypRYLv2vv_PixhdPHhNr3JR8wRlWwmRozBBWFEVyZX0dHnYq60yA8pVpg5OX2EhaDm0AmbaYoftSKsTyf1VHWlJnvzlCmyp9HqtFH8FoZzftVTCYhDfhpKRTvqDcJTJLdAexlZG8HIUc9?key=aoQS1ScS7KXCoFCH2o5hHg) We hope you found these recommendations for the FSMA 204 sortable spreadsheet useful - for more guidance [download our full sortable spreadsheet example here](https://trackvision.ai/fsma-204-spreadsheet). We are offering free consultations to help businesses navigate FSMA 204. During this in-depth 1 hour personalized session, we will: - Provide an overview of the FSMA Section 204 Food Traceability Rule - Review the FDA requirements for your business, identifying the Critical Tracking Events (CTEs) and Key Data Elements (KDEs) you’ll need to gather, record and share with your business partners - Demonstrate how to use the Sortable Spreadsheet for your business - Discuss how to deal with common challenges you might face as you scale, including: - How to receive and share data electronically with business partners - How to use barcode scanning to reduce labor - How to automatically generate sortable spreadsheets for any set of data the FDA requests Book a timeslot that suits you using the calendar below!     28 August 2024 | [Jonathan Ling](https://trackvision.ai/blog/author/jonathan-ling) share: Recommended for you [Our FSMA 204 Solution](https://trackvision.ai/solutions/fsma-204) [Why is data sharing so hard?](https://trackvision.ai/blog/why-is-data-sharing-between-trading-partners-so-hard) About the author Jonathan Ling With over 15 years experience in supply chain system integration, consulting and IT architecture, Jonathan is passionate about improving supply chain traceability and transparency through the application of open industry standards. ## Recommended reading NEW DSCSA [Case Study: How Hudson Scientific Hit Full DSCSA Compliance in 30 Days](https://trackvision.ai/blog/case-study-how-hudson-scientific-hit-full-dscsa-compliance-in-30-days) 25 August 2026 | [Curt Schacker](https://trackvision.ai/blog/author/curt-schacker) gs1 dpp [DPP in 2028: What Apparel Brands Need to Build Before the Deadline](https://trackvision.ai/blog/dpp-in-2028-what-apparel-brands-need-to-build-before-the-deadline) 17 August 2026 | [Curt Schacker](https://trackvision.ai/blog/author/curt-schacker) digital-link gs1 natural-trace [Full-Spectrum Product Authentication: Combining QR codes and Natural DNA tagging to fight food fraud](https://trackvision.ai/blog/full-spectrum-product-authentication-combining-qr-codes-and-natural-dna-tagging-to-fight-food-fraud) 10 June 2026 | [Jonathan Ling](https://trackvision.ai/blog/author/jonathan-ling) ## Get ahead with TrackVision updates Join our newsletter today and don't miss out on the opportunity to be part of a community driving innovation in tracking technology. Sign up now and be in the know! [![TrackVision\_Logo](https://trackvision.ai/hs-fs/hubfs/Logo-Long-Blue-On-Invis2-1.png?width=150&height=20&name=Logo-Long-Blue-On-Invis2-1.png "TrackVision_Logo")](https://www.trackvision.ai) ##### Headquarters ![Group 4266](https://trackvision.ai/hubfs/theme/Group%204266.svg) London United Kingdom ![Group 4266](https://trackvision.ai/hubfs/theme/Group%204266.svg) San Francisco United States [![Group 4508](https://trackvision.ai/hubfs/theme/Group%204508.svg) ![linkdin](https://trackvision.ai/hubfs/Group%204630.svg)](https://linkedin.com/company/trackvision-supply-chain-software/) - [Platform](https://trackvision.ai/platform) - [GS1 EPCIS 2.0 Repository](https://trackvision.ai/capabilities/epcis-repository) - [GS1 Digital Link Resolver](https://trackvision.ai/capabilities/gs1-digital-link-resolver) - [Digital Identities & Serialization](https://trackvision.ai/capabilities/digital-identities-and-serialization) - [Product Traceability](https://trackvision.ai/capabilities/product-traceability) - [AI for supply Chain](https://trackvision.ai/capabilities/ai-for-supply-chain) - [No Code Configuration](https://trackvision.ai/capabilities/no-code-configuration) - [Workflow and Rules Engine](https://trackvision.ai/capabilities/workflow-engine) - [Sensor Data Management](https://trackvision.ai/capabilities/sensor-data) - [Certification Management](https://trackvision.ai/capabilities/certification-management) - Solutions - [FSMA 204](https://trackvision.ai/solutions/fsma-204) - [DSCSA](https://trackvision.ai/solutions/dscsa) - [Digital Product Passport](https://trackvision.ai/blog) - [Provenance Assurance](https://trackvision.ai/solutions/provenance) - [Recall Monitoring](https://trackvision.ai/solutions/recall-monitoring) - [Recall Execution](https://trackvision.ai/solutions/recall-execution) - [Product Diversion](https://trackvision.ai/solutions/product-diversion) - [Waste Reduction](https://trackvision.ai/solutions/waste-reduction) - [Certification Monitoring](https://trackvision.ai/solutions/certification-monitoring) - [Cold Chain Monitoring](https://trackvision.ai/solutions/cold-chain-monitoring) - [Carbon Footprint Reduction](https://trackvision.ai/solutions/carbon-footprint-reduction) - Industries - [Fresh Food](https://trackvision.ai/industries/fresh-food) - [Apparel](https://trackvision.ai/industries/apparel) - [Wine & Spirits](https://trackvision.ai/industries/wine-and-spirits) - [Grocery](https://trackvision.ai/industries/grocery) - [Restaurants](https://trackvision.ai/industries/grocery) - [Pharmaceutical](https://trackvision.ai/industries/pharma) - [Resources](https://trackvision.ai/resources) - [Blog](https://trackvision.ai/blog) - [About us](https://trackvision.ai/about) - [Contact us](https://trackvision.ai/contact) Copyright © 2026, Trackvision AI Ltd | [Terms & Conditions](https://trackvision.ai/terms-conditions) | [Privacy Policy](https://trackvision.ai/privacy-policy) ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Jonathan Ling", "url" : "https://trackvision.ai/blog/author/jonathan-ling" }, "dateModified" : "2024-08-28T14:42:13.563Z", "datePublished" : "2024-08-28T14:33:47.000Z", "headline" : "How to record the FSMA 204 Transformation CTE in a sortable spreadsheet", "image" : [ "https://trackvision.ai/hubfs/FSMA%20Spreadsheet%20Featured%20Image%202-1.png" ], "mainEntityOfPage" : { "@id" : "https://trackvision.ai/blog/how-to-record-the-fsma-204-transformation-cte-in-a-sortable-spreadsheet", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://trackvision.ai/hubfs/Logo-Long-Blue-On-Invis2-1.png" }, "name" : "Trackvision AI Ltd" } } ```