9/13/2023 0 Comments Convert columns to rows in excel![]() I'm looking for a formula or macro to convert the list so that the columns are the fields and the rows are the records. Further some have fax#'s and others don't and others have emails and others don't. I have tried the text to column tool but found its a bit inconsistent when you have towns or states with two part names or two part addresses. I've been looking around, but am not sure if I'm using the correct search terms.I have an Excel file (attached) that lists contact information as a block of 4-6 rows and I want to convert to columns. Paste the copied data using Paste Special, go to Transpose feature. Select the first cell of the destination range into which you want to copy the transposed data. Copy the selected cells either by right clicking the selection. I'd be hugely appreciative of any OFFSET experts who can help me, or point me in the right direction if this has been answered before. This can be done simply by selecting the rows and columns. ![]() 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 |