transpose

  1. B

    How to change Pivot Format

    I have data of image links in excel. Some of my SKUs have 2-3 images. But the problem is all of them are in different rows. I want my images to be displayed as Main SKUs in Rows and their multiple image links in columns in front of them. Please help, Thanx. Raw Data Main SKU Image Links...
  2. B

    Transposing Data By Matching Criteria

    Hi All, I am attempting to take a table like this: and transposing the "Loss Used" amounts so they are transposed to give each "Loss Year" row a horizontal breakout of when these amounts were actually used. The output should look something like below: Right Now those are static linked...
  3. gfdwer2

    VBA Code for Replacing Row values by matching unique code

    Hi guys, need help finding VBA code for this. Please see pictures attached. For example (Picture 1) IF I input 5 in (Sheet 1, Range C4), THEN the values in Sheet 1 under Row 8 should replace the values in Sheet 2 at the right side of special code 5, since the special or unique codes matched...
  4. F

    Multiple email addresses in one cell to vertical column

    We have a mess... We are using the newest version of excel on windows platform and have a massive list of email addresses that are unfortunately combined into one column in excel, the largest combination containing 157 email addresses in one column cell. Our objective is to move all of the...
  5. V

    Transpose data from one column to several ones

    Good night everyone, I have a list of data all in one column that I need to separate in several columns. Raw source: Column A Text 1 Text 2 Text 3 ... Tex 8 Text 1 Text 2 Text 3 ... Tex 8 Text 1 Text 2 Text 3 ... Tex 8 up to 7,000 lines. I would like something like this: Column Text 1...
  6. J

    Advanced Transpose and/or grouping help

    I need help, I'm on a MAC and don't know how to use VBA's. Previously I would have used MS Access, but.... Mac! Here is what my data looks like: PDP URL IMAGE URL IMAGE ALT TEXT abc.com/page1.html abc.com/images/banana.jpg Banana abc.com/page1.html abc.com/images/apple.jpg Apple...
  7. M

    Taking a list that fills multiple columns and turn it into a list with only 2 columns

    I currently have a list of clients where in some cases, the clients have multiple client numbers which are in different columns. I need to move those with multiple client numbers to have the client number on it's own row. My dataset currently looks like this: CLIENT CODE 1 CODE 2 CODE 3 CODE...
  8. Emanuele

    Multiple column and String extract VBA

    Hi guys, I would like to know if there is a way to add more than 1 adjacent column for the presented code that Fluff helped me to modify in this Post Furthermore it's possible to apply a string extract (for example, extract the first 4 and the last 4 characters and put them in different column)...
  9. N

    How to transpose without replacing

    I need help please. I need to transpose the emails without replacing the existing information in the columns where the information will be pasted. I need only 3 columns per person but several rows if the person has more than two emails Moderator edit: Images removed as probably genuine email...
  10. Emanuele

    Transpose Data

    Hi guys, i would like to know how to add the transpose option to that part of code Thx! Set DestSh = ActiveWorkbook.Worksheets.Add Last = LastCol(DestSh) Set Copy1 = sh.Range("C10:AZ10") With Copy1 DestSh.Cells(1, Last...
  11. Emanuele

    Modify VBA Consolidating data adding transpose option and removing the delete option

    Hi, everybody, I'm new to the VBA script. I'm trying to use a script in VBA that is working but I would like to modify it so that I get the files, taken from rows, in the same columns. Also I would like to know if it's possible to avoid deleting the created worksheet every time, but simply do an...
  12. J

    function to return unique values to activecell

    Good Morning from California, I am trying to turn a subroutine that I have borrowed from @hiker95 into a function but I cannot get the output the dictionary to the activecell. I have tried a number of ways, but I just can't figure it out. I have verified that all of the values are being stored...
  13. M

    Using transpose or other way to make a table

    Hello, is there any chance to make the table in sheet "PL_FORM" transposed to the table in sheet "AS_FORM" automatically? I've tried everything I know but nothing does the trick :( Please help me Thanks in advance, Cheers.
  14. B

    Transposing text from a website

    Hello Everyone, I'm struggling to find a solution for a quite common issue I guess. I am about to copy a lot of text from different websites on a daily basis. Currently it looks like this (I.ex.: Bitcoin Price Chart (BTC) | Coinbase) Market cap $143.7B Volume (24 hours) $28.0B Circulating...
  15. R

    Transpose Data

    Dear All, Please help me. I have data like this SHORT LONG NOUN MODIFIER ATT N1 ATT V1 BELT,A56 BELT,DESIGNATION:A56 BELT -- DESIGNATION A56 BELT,A57 BELT,DESIGNATION:A57 BELT -- DESIGNATION A57 And I want it like this BELT,A56 BELT,DESIGNATION:A56 BELT -- DESIGNATION A56...
  16. A

    Partial Transposing

    Hi, I want to transpose data from given table to wanted table without using macro. In given data, Product numbers are given on the A column and each dates are on the other columns. Crossing cells contains production quantity. How can i reach the wanted data without using macro. Given table...
  17. B

    Have a sheet with approx. 900+ rows. I need a formula that will automatically transpose items horizontally if the address is the same. (see pic)

    I am trying to save lots of time and headache, so any help is appreciated! There are many addresses that have multiple tenants. I need the tenants horizontally transposed into the same row so that I can use this as a mail merge. I guess part two of this is that it would be great to also have a...
  18. T

    Help copying data and transpose from one sheet to new sheet

    I have an issue. I told my wife I could write a script for this. Well its a bit out of my range. I thought it was easy but its not for me because I dont do this enough. I have a spreadsheet and lets say I need to copy A2, D2, and E2 to another sheet 20 times but I also need to transpose the...
  19. D

    Transpose columns to rows from 1 sheet to another sheet with VBA with ongoing columns

    I have a constantly-updating spreadsheet I use to track projects, but I want to create a summary view for internal stakeholders. I'm looking to transpose my columns to rows from 1 sheet to another sheet. The issue I run into is that as new projects get added on to the original list (as a new...
  20. J

    VBA Copy & Paste Data Loop

    Hello, I am looking for VB code to copy data from one sheet, and paste it onto another sheet in a different format. Here is the current format: <colgroup><col width="70" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;"> <col width="88" style="width: 66pt...

Some videos you may like

This Week's Hot Topics

Top