Convert an excel file with many fields into one with a few specific fields

Sportsmen · #10 11-19-2022, 10:41 AM

Name participants Last Name, Participants First Name
ID
Exp.
St
Gr School Grade
Team School
Rate
Local

I should have done this before. The only things I need are Participants Lane, First name in the name field, school grade in the GR field, and School in the team field (I adjusted our website, so It should be correct for our next event. All the other fields can be blank since my other program will add them in. However, even though they are blank, I need those fields to be in the sheet, or else my program will not read the file.

Thank you guys for all the help!

Quote:

Originally Posted by p45cal

You'd better say how you want map these headers:
Order ID
Email
Financial Status
Paid at
Fulfillment Status
Fulfilled at
Currency
Subtotal
Shipping
Taxes
Amount Refunded
Total
Discount Code
Discount Amount
Shipping Method
Created at
Lineitem quantity
Lineitem name
Lineitem price
Lineitem sku
Lineitem variant
Lineitem requires shipping
Lineitem taxable
Lineitem fulfillment status
Billing Name
Billing Address1
Billing Address2
Billing City
Billing Zip
Billing Province
Billing Country
Billing Phone
Shipping Name
Shipping Address1
Shipping Address2
Shipping City
Shipping Zip
Shipping Province
Shipping Country
Shipping Phone
Cancelled at
Private Notes
Channel Type
Channel Name
Channel Order Number
Product Form: Participants First Name
Product Form: Participants Last Name
Product Form: Address
Product Form: Address (Line2)
Product Form: City
Product Form: State
Product Form: Postal Code
Product Form: School
Product Form: Additional Illinois Schools
Product Form: School Grade
Product Form: Email
Product Form: Phone 1
Product Form: Phone 2
Payment Method
Payment Reference

to these:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Save File with specific name from fields input.	PM1	Word	17	10-04-2020 07:22 PM
Linking Specific text fields in PP to specific cells in an Excel table	GWRW1964	PowerPoint	0	02-26-2018 07:37 AM
Exporting specific data fields from MS Word 2013 to a MS Excel 2013 spreadsheet	Labyrinth	Word	7	07-19-2016 01:35 PM
Word 2010 - DOCX File with fields -> PDF with fields	senglory	Word	2	03-27-2012 10:10 AM
Read text Report file with VBA and write parsed fields to Excel workbook	tpcervelo	Excel Programming	1	01-05-2012 10:14 PM