transpose rows

Hi everyone. I am trying to make a chart with demographic data, and I need to rearrange the data. I've been searching for a thread about this query, but all I found refer to Multiple Rows to Single Columns, and resulting columns on top of each other. My dataset is a table of 103x496 and I cannot...

Hello, can anyone tell me how to transpose these rows while keep 1 value consistent. For example, transpose the following data: <tbody> Kit Component 1 Component 2 Component 3 Component 4 ABC S001 S002 S003 DEF S006 S007 S008 S009 </tbody> Into this new format: <tbody> Kit...

Hello, I had originally posted this last week and thought a separate post answered my question. However, I cannot modify that formula well enough to work here so I'm posting again! I'm looking to move values that show as additional rows to a separate column within the row it is truly associated...

Nevermind!

Hello everyone! mrexcel has been my top resource when it comes to Excel-related questions. Great to be a member now. What follows is a tricky combination (for me, that is) of - starting from several rows named "A", "B", ... with blank cells, zeroes and values larger than zero in columns named...

Hello, So I have the results of a survey and the output given were <tbody> Name Prof Course Description Prof2 Course3 Description Prof5 Course6 Description Prof8 Course9 Description Prof11 Course12 Description Prof14 Course15 Description </tbody> Each row has the responses. However I need...

Hello! Firstly, i d like to congratulate every single member who is contributing to this wonderful forum. Amazing job and useful replies which saving us from 1000's of working hours. I have made a quick search on the forum for similar topics, but my knowledge in VBA is at a very embarrassing...

Hi, I want to break down every row into multiple row where a part of it would be carried forward from the parent and the last column would be the transpose of the remaining part of the parent row. Here's an example. Table 1 (static column A, B. variable column: C, D, E, F...): <tbody> Column...