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?
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?