First of all, apologies for the title, I can't really describe this well in title.
I have a dataframe that looks like this:
df = pd.DataFrame([[123,124,125,126],
['FX10', 'FX11', 'FX12', 'FX15'],
[['A', 'B', 'C'], ['X', 'Y'], None, [1]],
]).T
df.columns = ['ID', 'Type', 'Multiple']
I want to convert the above table into something like this:
How can I do this?