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?
|A ||B ||C ||D ||E ||F|
|xx ||xy ||xds ||xsd ||124 ||163|
|xx ||xy ||xds ||xsd ||235 ||643|
|xx ||xy ||xds ||xsd || || |
|xx ||xy ||xds ||xsd || |
|ab ||abc ||abds ||asd ||124 ||164|
|ab ||abc ||abds ||asd ||152 ||667|
|ab ||abc ||abds ||asd ||236 || |
|ab ||abc ||abds ||asd ||235 || |
Thanks and apologies for broken language (not my primary language)