Forum Discussion
Copy paste transposed text with a formula to go in certain columns?
Hi all, I currently have a data set that looks like this: I would like to transpose my information down under columns H-L so that for ALL cells in A that contains "George", the...
What do you mean by XXX, YYY, JJJ? I do not see any of these information to your input data. XLOOKUP() will assist you. Show your desired output manually so that we can do that by formula.
- Note that some of the cells in Column A are called, for example, "578459JJJ5438543" or "854843XXX5845934"
I therefore want the data from columns B-F respective to these to be transposed under the columns that say "XXX" or "JJJ"
does this make sense?
