Hello I am new this forum so I hope I am posting in the right place.
I need to alter the way information in presented in a spreadsheet. I have attached a sample spreadsheet which hopefully illustrates
what is required.
Row 1 contains field names and row 2 the relevant data for a make and model of motor car. However I need this information presented
as single records for each product choice.
Rows 4 to 12 illustrate what I need.
This is a task that needs doing regularly so I need a method that can automate this for 4000 product lines.
Thanks in advance.
I need to alter the way information in presented in a spreadsheet. I have attached a sample spreadsheet which hopefully illustrates
what is required.
Row 1 contains field names and row 2 the relevant data for a make and model of motor car. However I need this information presented
as single records for each product choice.
Rows 4 to 12 illustrate what I need.
This is a task that needs doing regularly so I need a method that can automate this for 4000 product lines.
Thanks in advance.