Hi all, Mynda said to try here if we had no luck ourselves (which we've not) so here goes ...
Each semester we get very large spreadsheets with student results in a format we need to process so we can upload it to SalesForce. So far it's being done manually (i.e. copy + paste/transpose)
In the raw data, every row is a subject result and each student does multiple subjects so, for each student there are multiple rows.
We need to convert this multi-row data into a single row.
Some of the multi-row data is repeated (see yellow block in workbook).
The column data for each student needs to be transposed into the single row (see green hues to black in workbook).
I have Microsoft 365, Excel v2406, on a PC.
Thanks in advance, Josh
There is no attachment. Please try again and don't forget to press "Start upload" before you submit your reply.
Thanks Riny, I did attached and start upload but I got an error message ... the post went up, but seemingly not the attach. Trying again. Josh
One approach I took was to create a pivot table in Power Pivot. Create a measure to group the unit codes and unit names.
Thanks Alan, we're taking a look at it now. My colleague knows a lot more about Excel and SaleForce so she'll ultimately be the one that'll see if it'll make things work.
That said, I added some fresh data in between Tom Jones and John Smith and it worked nicely.
I notice columns A-G have to be identical. In the file I uploaded I forgot to change the GPA in G11 from 5 to be 4.5 (occasionally GPAs vary) and that threw CARS4000 into H33 and the title into H34.
