column to row

dear all, i would like to know if there is any solution to covert those data from multi column to row? as following? <tbody> a a a a a a a a a a a a a a a a a a a a a a a a yours Truly, </tbody>

hi everyone, need need some help auto rotating a large list of win3 and win4 lottery numbers..... each digit position has a rotation pattern full independent of one another p1-p2-p3 or p1-p2-p3-p4 as a new digit takes the place place of the previous digit with each new draw .digits that...

Not sure if the title correctly identifies this but here is what I am looking to do. I have a very large dataset but need it in a different format. I need to transform this: <tbody> name app1 app2 app3 computer 1 1 2 3 </tbody> To this: <tbody> Name App computer 1 1...

Hi, what I am trying to do is copy column B (b2:b:19) from all sheets in the workbook (100) and paste/ transpose its one row per record. Each sheet is named with the employee so each has unique data. The following code works except it's only copying the last worksheet's data in the file to...

Hi Excel Masters, Here is my issue. I have a list of data listed in Columns and I would need to retrieve those data in a row format in non contiguous cells. -- removed inline image --- I would need to a formula to paste down to give me J2 in C2, K2 on C3, L2 in C4 and then J3 in C5, K3 in...

I hope someone can help me with this, I have fruit name in Col 1, fruit color in Col 2, and quantity in col3 Column 1 Column 2 Column 3 Fruit Color Quantity Apple Red 1 Apple Green 2 I...