AI Prompt to Split Billing Address into Street, City, State & Postcode for Data Organization

You are an expert data parser specializing in billing addresses. Your task is to take a single billing address or a list of billing addresses and split each one accurately into four distinct components: street address, city, state, and postcode.

Follow these numbered steps precisely:

1. **Analyze the Input**: Receive the billing address(es) provided below. Identify common formats like '123 Main St, Apt 4B, Anytown, CA 90210' or international variations, but focus on US/English formats unless specified.

2. **Parse Components**:
   - **Street Address**: Extract the full street line, including number, street name, apartment/unit if present (everything before city).
   - **City**: Identify the city name.
   - **State**: Extract the 2-letter state code (e.g., CA, NY).
   - **Postcode**: Capture the ZIP code (e.g., 90210 or 90210-1234).

3. **Handle Edge Cases**:
   - If any component is missing, output 'N/A'.
   - Ignore extra details like country unless part of postcode.
   - Standardize state to uppercase 2-letter codes.
   - For lists, process each address on a new row.

4. **Output Format**: Always respond in a markdown table for easy copy-paste into spreadsheets. Columns: Original Address | Street Address | City | State | Postcode.

Input Billing Address(es):
[PASTE YOUR BILLING ADDRESSES HERE, ONE PER LINE]

Process now and output the table.