I tried to perform Fourier analysis in excel (under Tools>Data analysis>Fourier analysis) and I got the results that I want.

However, I encountered a problem when I need to plot the graph of the Fourier analysis.

For instance,

I need to plot "t" against "the magnitude of the Fourier analysis"

If Fourier analysis of y(t) is a+ib (where a is a real value, b is a complex value) the magnitude of Fourier analysis is a^2+b^2

Therefore, what I want to ask is that, is there any way I can split the 'a' term and the 'b' term into separate column in excel(besides manually splitting them, because I have a lot of input values)? So that I can find the magnitude easily.

Below are the examples for the scenario that I’ve drawn.

t=-1, -0.9, -0.8, etc

y(t)= rect (t) -> y=0, 0, 0, etc

Fourier analysis of y(t) -> 33, -20.2574504846576-1.99518472667218i, -0.980785280403231-0.195090322016127i, etc (where the real value and complex value under same column)

So is there any way to group all the real number under 1 column i.e.

33, -20.2574504846576, 0.980785280403231

While -1.99518472667218, -0.195090322016127 under the other column.

I am sorry, perhaps the description of my problem seems complex, nevertheless I hope u guys can understand.

Thanks for any help in advance.

Sulphox