I have this issue:
to simplify -
I have 5 orders I have 5 items that have varying prices and I have 5 customers. Not all customers sell these items. I also have different shipping addresses and customer contacts based on order numbers. Users can update pricing, contacts and shipping info.
I want a way for the user to update contact info as a group or pricing individually. I actually have 200k + rows of data.

Orders	Items	price	customers	contact	Ship Contact	shipto
111	a	0.2	Shop	Bill A	Zach J	125 Main
111	b	1	Shop	Bill A	Zach J	125 Main
111	c	0.05	Shop	Bill A	Zach J	125 Main
111	d	1	Shop	Bill A	Zach J	125 Main
111	e	0.05	Shop	Bill A	Zach J	125 Main
222	d	0.9	Shop	Bob S	Carol F	126 Main
222	e	1.85	Shop	Bob S	Carol F	126 Main
333	a	0.03	Shop	Sue T	Sam V	128 Main
333	e	9.45	Shop	Sue T	Sam V	129 Main

Example for order number 111
Change contact 'Bill A' to 'William G' And shipto to '345 Center' (in all columns at one time) and price for item d to .90

What is the best way to achieve this?

Any help is appreciated

• Edited by CF_AARDVARK 16 hours 38 minutes ago updated

Can you consider a view that uses the dynamic filter of [Me]

Do you have an example?

I do not have a people picker for this list. Not too familiar with [ME] filter

• Edited by CF_AARDVARK 15 hours 27 minutes ago