Hi Experts,
I am working on 100+ reports and used Power Query to create a table that shows each header in the spread sheet is used as data. Here is a sample problem health report say Covid reports. There are 6 spreadsheets with data on Covid, so I got a table which report uses what header (Table) likewise there are other health reports having common headers. I need an idea of what tool and how to co-relate
Each of these spreadsheets are output from various systems and databases. Once I get the common links between each of the headers in the spread sheet, I will map them to the systems and create matrix.
Further details on Covid spreadsheets Repart 1
1.ID, 2. Place 3. vaccine status 4. Partial flag
Report 2: 1. ID 2. Name 3. GP/ Nurse name 4. ID of the GP/Nurse 5. Batch No
Repoert 3: 1. ID, 2. Name, 3. Address 1, 4. Address 2, Region, State. etc
Now I have a matrix of all the above spreadsheets and who is using what headers,, using power query. I need your help to visualize this into a meaningful story so I can use it for 100s of spreadsheets I need to analyze.