transpose and loop

  1. R

    Data Transpose

    Hello All, I need help in transposing the data below using Table ID as uniqueID, basically every time the integer in TableID increments, create a new row with the data transposed. Thank you in advance. TableID VendorID Question Response ----> TableID VendorID What's your...
  2. G

    Transpose every X rows to columns (Automation)

    Hello, I would like to transpose a range of data (A1 to KJ1) from every second row (row 1, row 3, row 5, until the last row) under one single column (e.g. column C) in the same sheet. I am having difficulty creating a macro with a loop that will help me do this. I tried following some...
  3. D

    Transpose VBA not working

    Hello All, I am having an issue with this little piece of code. For some reason it is only transposing the information every other line and has been driving me crazy. I am still pretty new to VBA, so any help would be greatly appreciated. Dim numrows As Integer Dim counter As Integer Dim x As...
  4. E

    shift segment of a rows to next rows

    <colgroup><col><col><col><col><col></colgroup><tbody> Data looks as below want it as below May 05 2019 May 05 2019 Jun 17 2019 Aug 9 2019 a a e sg rs rs a dgh 1 1 45 1234 [+1] [+1] Jun 17 2019 e a 45 Aug 9 2019...
  5. S

    Is there a formula (ideally) that can take some semi-structured data in one column and split it into multiple columns?

    I have a data set with around 10,000 rows in one column that contains approximately 1,500 individual profiles. https://monosnap.com/file/kInwZwsYoJuvhBsY9pQESDxGGZgZ3r I need to transform this data into the following columns Twitter Handle Following Followers Avg. Likes Avg. Retweets...
  6. M

    VBA Macro - Transpose with conditions

    So I need your help! Firstly I am a student and don't really know much about VBA, because my teacher skipped those classes, whatever... I have a table with a long number of rows and data in columns.I wanna transpose them to rows and deleting duplicates, so it's better to review the data. I'm...
  7. N

    transpose of data from columns to multiple row with reference to specific data

    Hello All, Below is my input table: <colgroup><col><col></colgroup><tbody> Compound Folder Name File name electrical documents a.pdf electrical documents b.dwg electrical documents c.pdf electrical documents d.xyz mechanical documents a1.pdf mechanical documents b1.dwg...
  8. A

    Split text separated by commas in single cell into individual rows

    Hi, I have a spreadsheet with data in A3:G200. Column E has data that is sometimes separated by commas in a single cell but not all of the time. For example (E13 has "shu, tihg, est" and E14 has "uth") I am trying to have a new row inserted for each text that is separated by a comma without...
  9. J

    VBA / Copy range and transpose

    Hi guys, I'd appreciate a little assistance with this issue as my VBA knowledge is too little and I'm not having luck with searching and trying other people's code: I've got a single column with over 11,000 rows of data. In it there are ranges of information that are identifiable because the...
  10. J

    Transpose loop after blank cell

    I'm working in the middle of a macro which copies data from one column based on the product ID# of a different column. If there is just one product ID# then the formula is simple however, in some circumstances there are several product#s that are the same and in that case I need to copy all of...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top