Sep 01 2022 01:04 AM
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", their respective cells in columns B-F will be transposed under column H.
Likewise the same for all cells that contain any of the titles in column I-L
The trick is that all the cells in column A contain the title in columns H-L, however I can't figure out how to get this done
I hope my question makes sense? Otherwise please let me know and I'll be happy to elaborate :)
Kind regards,
Jyggalag
Sep 01 2022 01:42 AM
I am currently facing this issue when attempting to do it myself by the way:
Sep 01 2022 01:46 AM
Sep 01 2022 01:49 AM