transpose data

Hi Friends, I have a VBA automation to be completed as part of my work. I have to copy data from workbook1 to workbook2 (different workbooks), but the challenge is data needs to be transposed based on criteria, simple transpose is not working as need to check some...

Morning, Hoping someone might have knowledge that may help me. I have to run a data pull every month. It comes in a certain format, and I need to transpose it into another format. I understand the transpose part, but only for a single set of data. My data is about 6000 rows long. This is the...

Hi, Please I am new to VBA. I have two worksheets. One on my laptop (and workmates. clones) and the other on office 365 Onedrive. when my colleagues fill their respective workbooks each on their systems and click a submit button, the data in the selected range is pasted in the Onedrive...

Please help me with my excel project. I have a stock trading spreadsheet with a database I export from my trading platform sorted vertically by execution date (regardless of whether Its a buy or a sell). I am trying to think of a way to dynamically transpose my database horizontally, grouped by...

I have a Excel document made up of 2 worksheets - one entitled "Support Register' and the other entitled 'Services' On the support register sheet, we have every client in Column B from Rows 9:120, and all our services across the top in Columns B8:ZZ8. I am attempting to make it so when I...

Hi I have a multiple sheet workbook - one of the worksheets has a series of event headers that run across 5 merged cells ("event1"= D2:H2, "event2"= I2:M2, "event3"= N2:R2 etc) I have a summary sheet that pulls statistics from the entire workbook and I would like to have a summary of the event...

I want to transpose data (shifting data from row to colum) but I wants header row along with every colum (while I have transposed data ).

Hello. Could someone help me out with a vba code. I am currently learning vba but i cannot figure out how to code this issue. I am trying to copy data in a column on one sheet (sheet1), then paste it on another sheet (sheet2), but this time, evenly spaced out every 9 rows. The number of data...

Hi everybody.. I'm looking for help to update the below code to transpose data from Column format to Row format. I have the below code (thanks Yongle for your help!) that copy values in a set of column cells when a button is pressed and pastes those values onto another tab. If the user...

Hello all, I am trying to create an At risk register so i can track my student that have several classes. Each tutor has there register that they enter an (A)-Absent, (P)-present or (L(10))-Late and number Minutes, i need something that will look over the other two subject spreadsheets for a set...

Hello, I am looking for help with a macro to change the format of a file to transpose data so it is going down versus going across. I need this to be a loop for each record I have. The following link provides an image of dummy data both the before and after formatting https://ibb.co/fv4grR ...

Hi I have a sheet which will contain a qty in any of a number of columns which i need the data transposing where there is a value. This is what the sheet will look like before the transpose, I then want it to find the data and put it int a sheet or new workbook like the images below; Any...

Hi... I required little help in making an entry employee wise with the data available. In a file, I'll be having 2 sheets DATA & ENTRY. I should use the DATA to make available of the ENTRY individual employee wise. DATA Sheet <colgroup><col><col><col span="6"><col...

Hi, dear excel vba.. masters! I have VBA code in Module1,2,3,4 In Module2: Private Sub pASTE_SPECIAL() On Error GoTo AkoGRESKA Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=True AkoGRESKA: Exit Sub End Sub Module4: Sub...

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

Hi Can any one help me on this transpose the available following data in a particular format. This data will continue for more than 650 rows & 26 columns <colgroup><col><col><col span="7"></colgroup><tbody> Emp. No. Name Comp1 Comp2 Comp3 Comp4 Comp5 Comp8 Comp9 2002 A 2000 800 1600 2500...

Hello. All cells in Sheet1 row3 contains some text or values (70 elements in total) but I need to copy/transpose contents only from every second cell from Sheet1 row3 into Sheet4 column B, starting from B4 cell (B4:B38, first 35 elements). Than again from Sheet1 row3 same action again, but now...

I have a requirement that involves a list of Personnel numbers copied into a spreadsheet that need to be transposed. They must be separated by a comma and concatenated into one cell so that they can be copied and pasted into a cell in a database. Unfortunately, this list could be just a handful...

Hello folks, I am currently struggling to set up a macro to transpose arrays of records based on conditions. I am quite new to VBA, so any tips and advice on how best to achieve this will be very much appreciated. Below is the format of my 'raw' data in Excel (Version 16.0.6741.2056) Column...

I am trying to make a PivotTable or some sort of Vlookup array. so I can see who is turning in paperwork, and narrow my scope by month. It looks like the following. <tbody> <tbody> <tbody> Employee 6/1/2016 6/2/2016 6/3/2016 6/4/2016 6/5/2016 6/6/2016 6/7/2016 6/8/2016 6/9/2016 6/10/2016...