I would love some help with the following problem.
I have two columns with multiple data. something like
And i want to make a transpose out of it. I have to mention that there is a empty row between every set of data and the hard thing for me is the variable number of E's and F's column for every set. let's say that in a set there are 5 F data, in a set 3 and so on (max 10)
is there a way I could have t in the following format?
Thanks and apologies for broken language (not my primary language)