Turn column into row excel5/3/2023 If this sounds overly complicated, it is and worse - it's not working. I then have been manually copy and pasting the next set of two rows. Inside the and areas is actually an INDEX-MATCH, so that the OFFSET starts on the correct row and updates as it moves to the next person. Right now, I have a formula seen in the table above. I've been going crazy trying to figure out how OFFSET can work. I've don't know how to use VBA or macros, and have a lot of data so I'm also not interested in manually transposing this. Person 2 Name5 Name 7 OFFSET(,0,ROW($A$1)) Person 1 Name1 Name 3 OFFSET(,0,ROW($A$1)) Username Product 1 Product 2 Service 1 Service 2Īnd this is what I want my data to look like: Username Product Service (What I've come up with, formula-wise, for PRODUCT:) In this example, I have it with every 2 columns but my actual dataset is every 3 columns. EDIT: I forgot to add that my need to transpose is recurring - every nth columns, I need to start to transpose again.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |