Hello Excel Guru people,
I have a question how to split text from one cell to columns and then multiply the row to number of splited text words.
It sound complicated so i have attached and example. forum.ozgrid.com/index.php?attachment/67429/
In first sheet there is text in column C
this text have a separator "/---; " . Needed word (number) is *********R (the numbers vary but the R and the separator is always there)
My goal is to split this text in column C to rows with count of this *********R numbers into the next "Result" sheet but for every number to have first the columns with the DFC (in first sheet column A) and then the 9 yellow colored columns.
In the example file the equal columns are colored in same color.
Hope my explanation is not too confusing
Thank you in advance for your help,