Log In
Register
Home
Active Member
July 3, 2024
Offline
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
Moderators
January 31, 2022
Offline
There is no attachment. Please try again and don't forget to press "Start upload" before you submit your reply.
Active Member
July 3, 2024
Offline
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
Trusted Members
October 18, 2018
Offline
One approach I took was to create a pivot table in Power Pivot. Create a measure to group the unit codes and unit names.
Active Member
July 3, 2024
Offline
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.
1 Guest(s)
