How to keep certain fields the same

Guessed · #2 09-03-2023, 04:21 PM

There may be some new analysis features in Excel but I would have thought you need to flatten the data into very tall table to be able to do all the clever Pivot Tables and Mail Merge functionality.
The structure I would be aiming for is:

Code:

Name     | Class   | Subject     | Mark
Joe      | Class 1 | Physics     | 45
Peter    | Class 1 | Physics     | 42
Joe      | Class 1 | Maths       | 48
Peter    | Class 1 | Maths       | 41
Jane     | Class 2 | Physics     | 45
Sally    | Class 3 | Chemistry   | 42
Jane     | Class 2 | RE          | 48
Sally    | Class 3 | Maths       | 41

Once you have restructured along these lines, the sorting, collating and mail merges become simple.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert an excel file with many fields into one with a few specific fields	Sportsmen	Excel	12	11-19-2022 02:34 PM
How can I set up tab to go back and forth between legacy fields and content control fields in a Word	Ikajed	Word	1	10-13-2017 06:06 PM
Displaying FORMTEXT fields when merge fields are empty or null	sfkHooper	Mail Merge	6	01-19-2016 04:24 PM
Macro to keep formatted form fields after mail merge or replace text with formatted form fields	jer85	Word VBA	2	04-05-2015 10:00 PM
Word 2010 - DOCX File with fields -> PDF with fields	senglory	Word	2	03-27-2012 10:10 AM