So, with a spectrophotometer you can build profiles for different lighting conditions providing you have measured spectral for those lights.
This can be done with a spectrophotometer however, I'm not aware of any tool that can generate these kind of specialty profiles directly. I1Profiler does let you generate a profile for a custom light source and a multiple of defined spectra such a "A." But it does not make a print look like it's 5000K illuminated with a 3500K bulb. What it does is correct color deviations from spikey waveforms so that a print will look most natural under that light. An example is in order.
Take the case of cheap, 2700K LEDs v regular 2700K incandescents. The cheap LEDs significantly attenuate reds and cyans even though they may appear to be the same CCT "white." Measuring the spectra of the LEDs then using I1Profiler to make a profile will push the printer to make the cyans and reds more saturated than a normal profile would do. The result is that a print made with the LED spectra profile will look much closer under LED light to that of a regular print under the incandescent. But it will still look warmer than the normal print viewed under 5000K. Even with the (relatively) attenuated reds.
There are ways to achieve what the OP indicates he desires but not directly. For instance one could download the CGATs spectral files from a profile target and go through all the spectral readings and adjust the reflectance values against the ratio of the 3500K/5000K spectra. Then generate a profile from that.
It will accomplish approximately the same result as the curves adjustment I recommended earlier and that requires no spectral info which the Spyder does not provide, nor a more complicated workflow requiring some customization of tools.