transpose

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)...

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...

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...

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...

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...

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.

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...

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...

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...

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...

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...

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...

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...

Hi, I have a range B2:Y194 of which I need to transponse from a row into a single column in cell A196, How would I go about doing this please?

I searched for a similar situation to mine and didn't see one (apologies if one exists and I missed it!) I have to format a long list of managers and their employees for mass emails, and the lists I get from our database are: <tbody> Manager 1 Employee A Manager 2 Employee B Manager 2...

I copy the following from a web page that was 4 column of rows. I pasted it in excel and showed up in one column. 9/26/2019 11:15 BTC 0.03142971 Completed 9/19/2019 12:01 BTC 0.02388444 Completed 9/10/2019 20:46 RVN 2414.582 Completed There are more than 100 of these groups in one column. I...

Hello community, I have a challenge that I am currently unable to overcome: In one worksheet, I have two columns; one entitled 'TYPE' and one entitled 'PRODUCT CODE'. Under TYPE, you will either have the word 'ALPHA', 'BETA' or 'OMEGA'. Under PRODUCT CODE, you could have one of a huge...

Is there a keyboard shortcut to paste Values with Transpose?

Excel Champs, Looking for creative solves for the below problem. I have a project sheet that looks something likes below in a table. I need a button function that can transfer in a separate sheet all the values in that row for that project transposed in a column. Master file (Sheet 1)...

Hi, Please help me in the next problem. In A1: ZL1 are texts. How could I do that, starting with A2, to transpose the data from the odd cells (A1, C1, E1, ..... ZK1) into A2: A345, and the data from the even cells (B1, D1, F1, ..... ZL1), from the range A1: ZL1 to be transposed into B2: B345...